Holidays in Lancashire
Discover the joys of a slower pace of life with a relaxing holiday by the water.
Book a boat, a cosy canalside cottage or a luxury hotel.
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.nationwide' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line:protected] => 53
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 53
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 16
[function] => getUnlimitedQueryRowCount
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
)
)
[2] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database.php
[line] => 136
[function] => __construct
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
[2] => 1
[3] => 9
)
)
[3] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Directory/Finder/Abstract.php
[line] => 62
[function] => getPagedRecordSet
[class] => Waterscape_Database
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
[1] => 1
[2] => 9
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 133
[function] => find
[class] => Waterscape_Directory_Finder_Abstract
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 75
)
)
)
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 75
)
)
)
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 262
[function] => render
[class] => Waterscape_Renderer_Component_HtmlRenderer
[type] => ->
[args] => Array
(
[0] => Waterscape_Component_DirectoryListingPage Object
(
[_is_location_page:private] => 1
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_preposition:private] => in
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 1391
[_view_component_id:protected] => 86
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/lancashire/holidays
[_path:private] => /in-your-area/lancashire/holidays
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/lancashire/holidays
[PHPSESSID] => abd78ce8300e38deedd662d8e919d33f
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 20
[page_id] => 1391
[view_name] => locations_holidays
[title] => Canal Holidays %LOCATION_PREPOSITION% %LOCATION_NAME% %LOCATION_COUNTY_NAME% | Cottages and Hotels %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals and Rivers
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/holidays.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/lancashire/holidays
[location] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[preposition] => in
[section] => holidays
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND a.county = 33 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY i.name
)
)
[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_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[37] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[53] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id