Skip to content

Instantly share code, notes, and snippets.

@lamp
Created November 22, 2010 16:16
Show Gist options
  • Select an option

  • Save lamp/710184 to your computer and use it in GitHub Desktop.

Select an option

Save lamp/710184 to your computer and use it in GitHub Desktop.
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:46 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"669", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442546", "seed_name"=>"development", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"P10wm9jEyWdtQBOOB2S46WSjTqs=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"669", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442546", "seed_name"=>"development", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"P10wm9jEyWdtQBOOB2S46WSjTqs=", "api_version"=>"1"}
~ (0.000020) SET sql_auto_is_null = 0
~ (0.000004) SET SESSION sql_mode = 'ANSI,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,TRADITIONAL'
~ (0.000009) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000007) SET sql_auto_is_null = 0
~ (0.000006) SET SESSION sql_mode = 'ANSI,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,TRADITIONAL'
~ (0.000003) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE (`activated` = TRUE AND `expires` > '2010-11-22 16:15:46' AND `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy') ORDER BY `id` LIMIT 1
~ (0.000002) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000023) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.051514, :after_filters_time=>1.9e-05, :action_time=>0.050693, :before_filters_time=>0.029952}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:46 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"8619", "format"=>nil, "action"=>"index", "campaign"=>{"order"=>"updated_at.desc", "page"=>"1", "limit"=>"15", "insert_domain"=>"com.videojuicer.asset"}, "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442546", "seed_name"=>"development", "user_id"=>"1", "controller"=>"campaigns", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"E+1DrzSZcbFb5h73ZjwLtJNrKcE=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"8619", "format"=>nil, "action"=>"index", "campaign"=>{"order"=>"updated_at.desc", "page"=>"1", "limit"=>"15", "insert_domain"=>"com.videojuicer.asset"}, "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442546", "seed_name"=>"development", "user_id"=>"1", "controller"=>"campaigns", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"E+1DrzSZcbFb5h73ZjwLtJNrKcE=", "api_version"=>"1"}
~ (0.000011) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
{:offset=>0, :limit=>15, :order=>[#<DataMapper::Query::Operator @target=:updated_at @operator=:desc>], :insert_domain=>"com.videojuicer.asset"}
~ (0.000006) SELECT COUNT(*) FROM `campaigns` WHERE `insert_domain` = 'com.videojuicer.asset' ORDER BY `updated_at` DESC
~ (0.345778) SELECT `id`, `name`, `insert_domain`, `presentation_id`, `user_id`, `disclosure`, `created_at`, `updated_at` FROM `campaigns` WHERE `insert_domain` = 'com.videojuicer.asset' ORDER BY `updated_at` DESC LIMIT 15
~ (0.000006) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 38 ORDER BY `id`
~ (0.000005) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 38 ORDER BY `id`
~ (0.000003) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 38 ORDER BY `id`
~ (0.000003) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 38 ORDER BY `id`
~ (0.000002) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 38 ORDER BY `id`
~ (0.000006) SELECT COUNT(*) FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 38
~ (0.000005) SELECT `id`, `campaign_id`, `tag_id` FROM `campaign_taggables` WHERE `campaign_id` = 38 ORDER BY `id`
~ (0.000004) SELECT `presentations`.`id`, `presentations`.`title`, `presentations`.`author`, `presentations`.`author_url`, `presentations`.`abstract`, `presentations`.`user_id`, `presentations`.`updater_id`, `presentations`.`callback_url`, `presentations`.`state`, `presentations`.`disclosure`, `presentations`.`publish_from`, `presentations`.`publish_until`, `presentations`.`document_layout`, `presentations`.`document_content`, `presentations`.`document_type`, `presentations`.`created_at`, `presentations`.`updated_at`, `presentations`.`image_asset_id` FROM `presentations` INNER JOIN `presentation_taggables` ON `presentations`.`id` = `presentation_taggables`.`presentation_id` WHERE `presentation_taggables`.`tag_id` IN (1, 2, 3, 4) GROUP BY `presentations`.`id`, `presentations`.`title`, `presentations`.`author`, `presentations`.`author_url`, `presentations`.`abstract`, `presentations`.`user_id`, `presentations`.`updater_id`, `presentations`.`callback_url`, `presentations`.`state`, `presentations`.`disclosure`, `presentations`.`publish_from`, `presentations`.`publish_until`, `presentations`.`document_layout`, `presentations`.`document_content`, `presentations`.`document_type`, `presentations`.`created_at`, `presentations`.`updated_at`, `presentations`.`image_asset_id` ORDER BY `presentations`.`id`
~ (0.000029) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 38 ORDER BY `id`
~ (0.000005) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 38 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000007) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 37 ORDER BY `id`
~ (0.000005) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 37 ORDER BY `id`
~ (0.000005) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 37 ORDER BY `id`
~ (0.000009) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 37 ORDER BY `id`
~ (0.000002) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 37 ORDER BY `id`
~ (0.000004) SELECT COUNT(*) FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 37
~ (0.000003) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` ORDER BY `id`
~ (0.000005) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 37 ORDER BY `id`
~ (0.000003) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 37 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000004) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 1 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000038) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 16 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 2 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 3 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000007) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 4 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000009) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 5 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 6 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 7 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000007) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 8 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 9 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000008) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 10 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 11 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 12 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000036) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 13 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000004) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 14 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 15 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 16 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 17 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 18 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000016) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 19 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 20 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 21 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 22 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000016) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 23 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 19 ORDER BY `id` LIMIT 1
~ (0.000009) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 24 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000008) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 25 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `width`, `height`, `user_id` FROM `assets_image` WHERE `id` = 5 ORDER BY `id` LIMIT 1
~ (0.000016) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 26 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 27 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000020) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 28 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 29 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 30 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `width`, `height`, `user_id` FROM `assets_image` WHERE `id` = 8 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 31 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000003) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `width`, `height`, `user_id` FROM `assets_image` WHERE `id` = 4 ORDER BY `id` LIMIT 1
~ (0.000013) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 38 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 5 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 40 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000004) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 6 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 48 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000009) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 4 ORDER BY `id` LIMIT 1
~ (0.000013) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 50 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000018) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 63 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000003) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `width`, `height`, `user_id` FROM `assets_image` WHERE `id` = 49 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 56 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 36 ORDER BY `id`
~ (0.000005) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 36 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 36 ORDER BY `id`
~ (0.000005) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 36 ORDER BY `id`
~ (0.000003) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 36 ORDER BY `id`
~ (0.000004) SELECT COUNT(*) FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 36
~ (0.000003) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` ORDER BY `id`
~ (0.000004) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 36 ORDER BY `id`
~ (0.000002) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 36 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000016) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000021) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 35 ORDER BY `id`
~ (0.000003) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 35 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 35 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 35 ORDER BY `id`
~ (0.000003) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 35 ORDER BY `id`
~ (0.000004) SELECT COUNT(*) FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 35
~ (0.000003) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` ORDER BY `id`
~ (0.000005) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 35 ORDER BY `id`
~ (0.000003) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 35 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000009) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000008) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000017) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 34 ORDER BY `id`
~ (0.000005) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 34 ORDER BY `id`
~ (0.000005) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 34 ORDER BY `id`
~ (0.000006) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 34 ORDER BY `id`
~ (0.000004) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 34 ORDER BY `id`
~ (0.000005) SELECT COUNT(*) FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 34
~ (0.000004) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` ORDER BY `id`
~ (0.000003) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 34 ORDER BY `id`
~ (0.000003) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 34 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.001986) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000032) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000198) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000016) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000008) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000008) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 33 ORDER BY `id`
~ (0.000010) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 33 ORDER BY `id`
~ (0.000002) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 33 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 33 ORDER BY `id`
~ (0.000003) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 33 ORDER BY `id`
~ (0.000021) SELECT COUNT(*) FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 33
~ (0.000004) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` ORDER BY `id`
~ (0.000005) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 33 ORDER BY `id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 33 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000008) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000021) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000009) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000074) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000008) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000011) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000009) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 32 ORDER BY `id`
~ (0.000077) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 32 ORDER BY `id`
~ (0.000003) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 32 ORDER BY `id`
~ (0.000003) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 32 ORDER BY `id`
~ (0.000004) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 32 ORDER BY `id`
~ (0.000004) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` WHERE `id` = 63 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 32 ORDER BY `id`
~ (0.000005) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 32 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000007) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 27 ORDER BY `id`
~ (0.000003) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 27 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 27 ORDER BY `id`
~ (0.000005) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 27 ORDER BY `id`
~ (0.000003) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 27 ORDER BY `id`
~ (0.000003) SELECT COUNT(*) FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 27
~ (0.000004) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` ORDER BY `id`
~ (0.000004) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 27 ORDER BY `id`
~ (0.000004) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 27 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000004) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000020) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 31 ORDER BY `id`
~ (0.000007) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 31 ORDER BY `id`
~ (0.000009) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 31 ORDER BY `id`
~ (0.000005) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 31 ORDER BY `id`
~ (0.000005) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 31 ORDER BY `id`
~ (0.000004) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` WHERE `id` = 61 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 31 ORDER BY `id`
~ (0.000007) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 31 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000003) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 30 ORDER BY `id`
~ (0.000004) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 30 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 30 ORDER BY `id`
~ (0.000018) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 30 ORDER BY `id`
~ (0.000004) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 30 ORDER BY `id`
~ (0.000003) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` WHERE `id` = 60 ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 30 ORDER BY `id`
~ (0.000007) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 30 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000004) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 29 ORDER BY `id`
~ (0.000005) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 29 ORDER BY `id`
~ (0.000003) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 29 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 29 ORDER BY `id`
~ (0.000003) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 29 ORDER BY `id`
~ (0.000004) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` WHERE `id` = 59 ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 29 ORDER BY `id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 29 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000003) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 26 ORDER BY `id`
~ (0.000003) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 26 ORDER BY `id`
~ (0.000003) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 26 ORDER BY `id`
~ (0.000011) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 26 ORDER BY `id`
~ (0.000004) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 26 ORDER BY `id`
~ (0.000006) SELECT COUNT(*) FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 26
~ (0.000005) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` ORDER BY `id`
~ (0.000020) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 26 ORDER BY `id`
~ (0.000004) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 26 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000372) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000010) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000008) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 0 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 25 ORDER BY `id`
~ (0.000005) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 25 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 25 ORDER BY `id`
~ (0.000003) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 25 ORDER BY `id`
~ (0.000007) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 25 ORDER BY `id`
~ (0.000005) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` WHERE `id` = 58 ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 25 ORDER BY `id`
~ (0.000007) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 25 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 24 ORDER BY `id`
~ (0.000003) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 24 ORDER BY `id`
~ (0.000002) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 24 ORDER BY `id`
~ (0.000004) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 24 ORDER BY `id`
~ (0.000330) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 24 ORDER BY `id`
~ (0.000004) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` WHERE `id` = 57 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 24 ORDER BY `id`
~ (0.000006) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 24 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000005) SELECT `id`, `campaign_id`, `protocol`, `host`, `path`, `http_query`, `exclude`, `created_at`, `updated_at` FROM `criterion_requests` WHERE `campaign_id` = 23 ORDER BY `id`
~ (0.000006) SELECT `id`, `from`, `until`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_date_ranges` WHERE `campaign_id` = 23 ORDER BY `id`
~ (0.000019) SELECT `id`, `campaign_id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `exclude`, `created_at`, `updated_at` FROM `criterion_week_days` WHERE `campaign_id` = 23 ORDER BY `id`
~ (0.000006) SELECT `id`, `campaign_id`, `from_hour`, `from_minute`, `until_hour`, `until_minute`, `created_at`, `updated_at` FROM `criterion_times` WHERE `campaign_id` = 23 ORDER BY `id`
~ (0.000006) SELECT `id`, `country`, `region`, `city`, `exclude`, `created_at`, `updated_at`, `campaign_id` FROM `criterion_geolocations` WHERE `campaign_id` = 23 ORDER BY `id`
~ (0.000005) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `updater_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` WHERE `id` = 56 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `user_id`, `campaign_id`, `role`, `duration`, `offset_time`, `offset_x`, `offset_y`, `anchor_x`, `anchor_y`, `click_href`, `click_target`, `asset_type`, `asset_id`, `created_at`, `updated_at` FROM `inserts` WHERE `campaign_id` = 23 ORDER BY `id`
~ (0.000007) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `campaign_taggables` ON `tags`.`id` = `campaign_taggables`.`tag_id` INNER JOIN `campaigns` ON `campaign_taggables`.`campaign_id` = `campaigns`.`id` WHERE `campaign_taggables`.`campaign_id` = 23 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
merb : worker (port 5555) ~ {:dispatch_time=>11.638085, :after_filters_time=>3.2e-05, :action_time=>11.631314, :before_filters_time=>0.004358}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:57 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"5861", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442557", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"fHrJno/uiBz8IQ6cOZvbkb1NpSQ=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"5861", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442557", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"fHrJno/uiBz8IQ6cOZvbkb1NpSQ=", "api_version"=>"1"}
~ (0.000005) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000002) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.024462, :after_filters_time=>2.0e-05, :action_time=>0.023695, :before_filters_time=>0.014526}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:57 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"2410", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442557", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"rXzQBUWHqyHZR1CpDQBWC+jTf4I=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"2410", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442557", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"rXzQBUWHqyHZR1CpDQBWC+jTf4I=", "api_version"=>"1"}
~ (0.000005) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000228) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000002) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.022032, :after_filters_time=>2.1e-05, :action_time=>0.021134, :before_filters_time=>0.013416}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:57 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"2824", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442557", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"pnLRA5i0tiZvO8GLUxmQ/7tXamo=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"2824", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442557", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"pnLRA5i0tiZvO8GLUxmQ/7tXamo=", "api_version"=>"1"}
~ (0.000003) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000010) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.213636, :after_filters_time=>1.8e-05, :action_time=>0.211515, :before_filters_time=>0.013095}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:58 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"245", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"69uu55CdnnyP/AggK4ebNPnSvKA=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"245", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"69uu55CdnnyP/AggK4ebNPnSvKA=", "api_version"=>"1"}
~ (0.000004) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.028877, :after_filters_time=>1.9e-05, :action_time=>0.027784, :before_filters_time=>0.01808}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:58 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"6539", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"kyTNFRgEvnwU/GK95suATZzvrDU=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"6539", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"kyTNFRgEvnwU/GK95suATZzvrDU=", "api_version"=>"1"}
~ (0.000005) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.034486, :after_filters_time=>2.0e-05, :action_time=>0.032482, :before_filters_time=>0.016715}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:58 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"9184", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"I+UYVvra0qEzLuMKB6s9tF5+474=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"9184", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"I+UYVvra0qEzLuMKB6s9tF5+474=", "api_version"=>"1"}
~ (0.000005) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000010) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000011) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.037231, :after_filters_time=>2.2e-05, :action_time=>0.036507, :before_filters_time=>0.022685}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:58 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"1140", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"60wSAF/zQgfyCqsRajudiLg8py8=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"1140", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"60wSAF/zQgfyCqsRajudiLg8py8=", "api_version"=>"1"}
~ (0.000005) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.033919, :after_filters_time=>2.1e-05, :action_time=>0.027992, :before_filters_time=>0.014058}
merb : worker (port 5555) ~
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Mon Nov 22 16:15:58 +0000 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"2331", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"BYDcHD5U4/AgVznYixMzO3hhOxQ=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"2331", "format"=>"json", "action"=>"show", "id"=>"1", "oauth_signature_method"=>"HMAC-SHA1", "oauth_timestamp"=>"1290442558", "seed_name"=>"development", "user_id"=>"1", "controller"=>"users", "oauth_consumer_key"=>"test_consumer_key", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_signature"=>"BYDcHD5U4/AgVznYixMzO3hhOxQ=", "api_version"=>"1"}
~ (0.000007) SELECT `id`, `name` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000002) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000004) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id` FROM `users` WHERE `login` = 'administrator' ORDER BY `id` LIMIT 1
~ (0.000003) SELECT `id` FROM `users` WHERE `email` = 'sup@test.videojuicer.com' ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.022578, :after_filters_time=>1.7e-05, :action_time=>0.021574, :before_filters_time=>0.014082}
merb : worker (port 5555) ~
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment