Exception Object
(
[message:protected] => Element with key 'google_map_key' does not exist in hashtable
[string:private] =>
[code:protected] => 0
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Util/Hashtable.php
[line:protected] => 85
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/%%FC^FCD^FCDECC39%%Route.tpl.php
[line] => 14
[function] => get
[class] => Waterscape_Util_Hashtable
[type] => ->
[args] => Array
(
[0] => google_map_key
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Smarty/Smarty.class.php
[line] => 1262
[args] => Array
(
[0] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/%%FC^FCD^FCDECC39%%Route.tpl.php
)
[function] => include
)
[2] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 35
[function] => fetch
[class] => Smarty
[type] => ->
[args] => Array
(
[0] => db:Component/Route.tpl
[1] =>
[2] =>
[3] =>
)
)
[3] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 20
[function] => fetchContent
[class] => Waterscape_Smarty
[type] => ->
[args] => Array
(
[0] => Component/Route.tpl
)
)
[4] => 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_Route Object
(
[_db:private] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
[_route_id:private] => 374
[_waypoint_mgr: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] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
)
[_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] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] =>
)
)
)
)
[_route_mgr: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] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
)
[_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] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
)
[_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] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
[_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 * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
)
)
[_component_id:protected] => 26
[_parent_id:protected] =>
[_template:protected] => Component/Route.tpl
[_page_id:protected] => 749036
[_view_component_id:protected] => 170
[_instance_name:protected] => route
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /things-to-do/walking/routes/374/glen-loy-forest-walks
[_path:private] => /things-to-do/walking/routes/374/glen-loy-forest-walks
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => things-to-do/walking/routes/374/glen-loy-forest-walks
[PHPSESSID] => 8a035544b4ae3c80d3ae57bab52a06ef
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 68
[page_id] => 749036
[view_name] => activities_route
[title] => %ROUTE_NAME% | %ROUTE_TYPE% | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright_notitleimg.tpl
[template] => Page/activities/route.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_RoutesAndRings
[path] => /things-to-do/walking/routes/374/glen-loy-forest-walks
[route_id] => 374
[PLACEHOLDER_ROUTE_NAME] => Glen Loy Forest Walks
[PLACEHOLDER_ROUTE_TYPE] =>
[onload] => mapInit();
)
[_count:private] => 17
)
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/%%D9^D91^D91BBB9F%%route.tpl.php
[line] => 5
[function] => smartyFunctionComponent
[class] => Waterscape_Smarty
[type] => ->
[args] => Array
(
[0] => Array
(
[name] => route
)
[1] => Waterscape_Smarty Object
(
[_is_for_print:private] =>
[_is_text_only:private] =>
[template_dir] => /home/waterscape/public_html/waterscape/var/smarty/templates/
[compile_dir] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/
[config_dir] => /home/waterscape/public_html/waterscape/var/smarty/configs/
[plugins_dir] => Array
(
[0] => plugins
)
[debugging] =>
[error_reporting] =>
[debug_tpl] =>
[debugging_ctrl] => NONE
[compile_check] => 1
[force_compile] =>
[caching] => 0
[cache_dir] => /home/waterscape/public_html/waterscape/var/smarty/cache/
[cache_lifetime] => 3600
[cache_modified_check] =>
[php_handling] => 0
[security] =>
[secure_dir] => Array
(
)
[security_settings] => Array
(
[PHP_HANDLING] =>
[IF_FUNCS] => Array
(
[0] => array
[1] => list
[2] => isset
[3] => empty
[4] => count
[5] => sizeof
[6] => in_array
[7] => is_array
[8] => true
[9] => false
[10] => null
)
[INCLUDE_ANY] =>
[PHP_TAGS] =>
[MODIFIER_FUNCS] => Array
(
[0] => count
)
[ALLOW_CONSTANTS] =>
)
[trusted_dir] => Array
(
)
[left_delimiter] => {
[right_delimiter] => }
[request_vars_order] => EGPCS
[request_use_auto_globals] => 1
[compile_id] =>
[use_sub_dirs] =>
[default_modifiers] => Array
(
)
[default_resource_type] => file
[cache_handler_func] =>
[autoload_filters] => Array
(
)
[config_overwrite] => 1
[config_booleanize] => 1
[config_read_hidden] =>
[config_fix_newlines] => 1
[default_template_handler_func] =>
[compiler_file] => Smarty_Compiler.class.php
[compiler_class] => Smarty_Compiler
[config_class] => Config_File
[_tpl_vars] => Array
(
[page_title] => %ROUTE_NAME% | %ROUTE_TYPE% | Waterscape.com
[page_description] => %ROUTE_NAME% %ROUTE_TYPE%. %ROUTE_TYPE% guides and %ROUTE_TYPE% routes including marked map from Waterscape.com
[page_keywords] => %ROUTE_NAME%, %ROUTE_TYPE%, things to do, routes, trails, guide, %ROUTE_TYPE% routes, %ROUTE_TYPE% guides, %ROUTE_TYPE% maps, waterscape.com
[page_metadata] => Waterscape_Model_Metadata Object
(
[_title:private] => Glen Loy Forest Walks
[_description:private] => Located on the west bank of the[/canals-and-rivers/caledonian-canal Caledonian Canal] just north of Banavie, the beautiful Glen Loy Forest offers some relaxing walks in a setting rich with indigenous and unusual wildlife and plants.
[_keywords:private] => Banavie, Glen Loy Forest, Ben Nevis, Erracht Oakwood Walk, walking, walker
[_alt_text:private] =>
[_author:private] => Waterscape.com
[_language:private] => en_GB
[_source:private] => www.scottishcanals.co.uk
[_relation:private] =>
[_format:private] => utf-8 Plain Text
[_identifier:private] =>
[_publisher:private] => Waterscape.com
[_coverage:private] =>
[_rights:private] => All rights reserved
[_contributor:private] => www.scottishcanals.co.uk
[_easting:private] =>
[_northing:private] =>
[_created:private] => 2008-04-14 15:59:49
[_updated:private] => 2008-05-19 01:42:28
[_indexed:private] => 2008-11-05T12:16:15+00:00
[_geo_data_id:private] =>
[_geo_data_type:private] => point
[_id:protected] => 93727
)
[response] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 68
[page_id] => 749036
[view_name] => activities_route
[title] => %ROUTE_NAME% | %ROUTE_TYPE% | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright_notitleimg.tpl
[template] => Page/activities/route.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_RoutesAndRings
[path] => /things-to-do/walking/routes/374/glen-loy-forest-walks
[route_id] => 374
[PLACEHOLDER_ROUTE_NAME] => Glen Loy Forest Walks
[PLACEHOLDER_ROUTE_TYPE] =>
[onload] => mapInit();
)
[_count:private] => 17
)
[request] => Waterscape_Request Object
(
[_mapping_path:private] => /things-to-do/walking/routes/374/glen-loy-forest-walks
[_path:private] => /things-to-do/walking/routes/374/glen-loy-forest-walks
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => things-to-do/walking/routes/374/glen-loy-forest-walks
[PHPSESSID] => 8a035544b4ae3c80d3ae57bab52a06ef
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[components] => Waterscape_Util_Hashtable Object
(
[_store:private] => Array
(
[title_header_image] => Waterscape_Component_ActivityHeaderImage Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT waypoint_id AS id FROM route_waypoint WHERE route_id = ? ORDER BY position ASC
)
[92] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[94] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[95] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[96] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[97] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[101] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[103] => Array
(
[sql] => SELECT s.next_stage FROM route_stage s INNER JOIN route r ON r.route_id = s.next_stage WHERE s.route_id = ?
)
)
[queryCounter] => 104
)
)
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[5] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[6] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[7] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[8] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM 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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[61] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[62] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[63] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[64] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[65] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[66] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[67] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[68] => Array
(
[sql] => SELECT * FROM templates WHERE template_path = ?
)
[69] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[71] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[72] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[73] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[74] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM route WHERE route_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM route_rating WHERE id = ?
)
[82] => Array
(
[sql] => SELECT type_id AS id, name FROM route_type WHERE type_id = ?
)
[83] => Array
(
[sql] => SELECT waterway_id AS id FROM route_waterway WHERE route_id = ?
)
[84] => Array
(
[sql] => SELECT route_id, town_id FROM route_town WHERE route_id = ? ORDER BY town_id
)
[85] => Array
(
[sql] => SELECT route_id, media_id FROM route_media WHERE route_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[88] => Array