Current run

gistfile1.txt

Processing MessagesController#update (for 33.33.33.1 at 2013-09-24 16:51:04) [PUT]
  Parameters: {"group"=>"8", "string_value"=>{"name"=>"", "pos_profile_id"=>"5"}, "search"=>{"search_name"=>""}, "controller"=>"messages", "message"=>{"name"=>"3 Regular Footlong Subs for 14.99 [after 4PM & Weekends]", "image_id"=>"2102", "frame"=>"0", "value"=>"", "priority"=>"3", "barcode_height"=>"24", "include_barcode"=>"0", "duration_unit"=>"Days", "answer"=>"", "redeem_suppress"=>"0", "barcode_placement"=>"1", "embedded_text"=>"<p>{{beg_date}} - {{exp_date}}</p>", "answer_inverted"=>"0", "string_rules_attributes"=>{"0"=>{"comparison"=>"between", "max_value"=>"", "string_type"=>"", "string_value_id"=>"", "printable"=>"0", "min_value"=>""}}, "start_date"=>"", "optional"=>"0", "barcode_format_id"=>"1", "end_date"=>"", "start_offset"=>"1", "text"=>"", "message_type_id"=>"4", "barcode_string"=>"", "image_placement"=>"1", "include_info"=>"0", "dynamic_date"=>"1", "cost"=>"", "include_pool"=>"1", "pos_id"=>"", "info"=>"", "barcode_print_string"=>"0", "duration_round"=>"None", "duration"=>"10", "embedded_text_2"=>"<p>{{receipt.header_address1}}</p>", "include_answer"=>"0", "state"=>"0"}, "_method"=>"put", "message_string_value_ids"=>[""], "action"=>"update", "authenticity_token"=>"WT2PvO+laDxYTtsyqa9woTWwcJBMiVJ6ByPXvDor4fo=", "associated_day_parts"=>["406"], "id"=>"22936", "commit"=>{"pinned"=>"save", "type"=>"save"}}
  User Load (1.1ms)   SELECT * FROM "users" WHERE ("users"."id" = 1788)
  Role Load (0.6ms)   SELECT * FROM "roles" WHERE ("roles"."id" = 1)
  RolePerm Load (1.1ms)   SELECT "role_perms".* FROM "role_perms" WHERE ("role_perms".role_id = 1)
  Perm Load (1.2ms)   SELECT * FROM "perms" WHERE ("perms"."id" IN (75,1,27,52,62,9,37,14,72,24,47,82,6,57,34,11,21,67,19,44,77,3,29,54,31,39,64,16,41,74,26,51,49,84,8,59,36,61,13,71,69,23,46,81,79,5,56,33,10,20,66,18,43,76,2,28,53,30,38,63,15,40,73,25,50,48,83,7,58,35,60,12,70,68,22,45,80,78,4,55,32,65,17,42))
  Entity Load (1.4ms)   SELECT * FROM "entities" WHERE ("entities"."id" = 140)
SETTING UP CURRENT VARS. CU: 1788 CEX: 140
GETTING SESSION APPS: {"enhanced"=>140, "coupon"=>140, "employee_messages"=>140, "game"=>140, "basic"=>140}
  Timezone Load (1.1ms)   SELECT * FROM "timezones" WHERE ("timezones"."id" = 6)
BROWSER: Firefox
  Message Load Including Associations (3.3ms)   SELECT "messages"."id" AS t0_r0, "messages"."name" AS t0_r1, "messages"."message_type_id" AS t0_r2, "messages"."text" AS t0_r3, "messages"."font_size" AS t0_r4, "messages"."frame" AS t0_r5, "messages"."image_id" AS t0_r6, "messages"."grid_type_id" AS t0_r7, "messages"."image_placement" AS t0_r8, "messages"."answer" AS t0_r9, "messages"."answer_inverted" AS t0_r10, "messages"."day_part_id" AS t0_r11, "messages"."nutrient_range" AS t0_r12, "messages"."nutritional_category_id" AS t0_r13, "messages"."min" AS t0_r14, "messages"."max" AS t0_r15, "messages"."entity_id" AS t0_r16, "messages"."created_by" AS t0_r17, "messages"."create_method" AS t0_r18, "messages"."created_on" AS t0_r19, "messages"."modified_by" AS t0_r20, "messages"."updated_on" AS t0_r21, "messages"."activate_at" AS t0_r22, "messages"."status_id" AS t0_r23, "messages"."version_id" AS t0_r24, "messages"."pos_id" AS t0_r25, "messages"."include_pool" AS t0_r26, "messages"."grid_format" AS t0_r27, "messages"."include_info" AS t0_r28, "messages"."embedded_text" AS t0_r29, "messages"."duration_unit" AS t0_r30, "messages"."duration" AS t0_r31, "messages"."duration_round" AS t0_r32, "messages"."game_freq" AS t0_r33, "messages"."info" AS t0_r34, "messages"."start_offset" AS t0_r35, "messages"."value" AS t0_r36, "messages"."cost" AS t0_r37, "messages"."priority" AS t0_r38, "messages"."optional" AS t0_r39, "messages"."barcode_format_id" AS t0_r40, "messages"."barcode_placement" AS t0_r41, "messages"."barcode_height" AS t0_r42, "messages"."barcode_print_string" AS t0_r43, "messages"."barcode_string" AS t0_r44, "messages"."embedded_text_2" AS t0_r45, "messages"."redeem_suppress" AS t0_r46, "messages"."state" AS t0_r47, "messages"."plain_text" AS t0_r48, "messages"."start_date" AS t0_r49, "messages"."end_date" AS t0_r50, "entities"."id" AS t1_r0, "entities"."entity_type_id" AS t1_r1, "entities"."name" AS t1_r2, "entities"."info" AS t1_r3, "entities"."enterprise" AS t1_r4, "entities"."lft" AS t1_r5, "entities"."rgt" AS t1_r6, "entities"."parent_id" AS t1_r7, "entities"."signature" AS t1_r8, "entities"."segment_type_id" AS t1_r9, "entities"."created_by" AS t1_r10, "entities"."create_method" AS t1_r11, "entities"."created_on" AS t1_r12, "entities"."modified_by" AS t1_r13, "entities"."updated_on" AS t1_r14, "entities"."update_sw_version" AS t1_r15, "entities"."store_number" AS t1_r16, "entities"."billing_status" AS t1_r17, "entities"."sign_up_date" AS t1_r18, "entities"."paid_date" AS t1_r19, "entities"."paid_through_date" AS t1_r20, "entities"."active_date" AS t1_r21, "entities"."cancel_date" AS t1_r22, "entities"."payment_method" AS t1_r23, "entities"."billing_interval" AS t1_r24, "entities"."fees_upfront" AS t1_r25, "entities"."fees_ongoing" AS t1_r26, "entities"."contact_name" AS t1_r27, "entities"."contact_email" AS t1_r28, "entities"."contact_phone" AS t1_r29, "entities"."street_address" AS t1_r30, "entities"."city" AS t1_r31, "entities"."state" AS t1_r32, "entities"."zipcode" AS t1_r33, "entities"."status" AS t1_r34, "entities"."cancel_reason" AS t1_r35, "entities"."account_number" AS t1_r36, "entities"."has_components" AS t1_r37, "entities"."lat" AS t1_r38, "entities"."lng" AS t1_r39, "entities"."street_address_2" AS t1_r40, "message_types"."id" AS t2_r0, "message_types"."name" AS t2_r1, "message_types"."info" AS t2_r2, "message_types"."entity_id" AS t2_r3, "message_types"."image_placement" AS t2_r4, "message_types"."default_rotation_style_id" AS t2_r5, "message_types"."message_type_group_id" AS t2_r6, "message_types"."game_base" AS t2_r7, "message_types"."start_date" AS t2_r8, "message_types"."end_date" AS t2_r9, "message_types"."repeatable" AS t2_r10, "message_types"."image_id" AS t2_r11, "message_types"."frame" AS t2_r12, "message_types"."locked" AS t2_r13, "message_types"."ric_code" AS t2_r14, "message_types"."updated_on" AS t2_r15, "message_types"."modified_by" AS t2_r16, "message_types"."created_on" AS t2_r17, "message_types"."created_by" AS t2_r18, "message_types"."create_method" AS t2_r19 FROM "messages" LEFT OUTER JOIN "entities" ON "entities".id = "messages".entity_id LEFT OUTER JOIN "message_types" ON "message_types".id = "messages".message_type_id WHERE ("messages"."id" = 22936) AND (entities.id=140 or (entities.lft>=318 and entities.rgt<20709) )
ELAPSED: 0.025854
  MessageMessageGroup Load (0.9ms)   SELECT * FROM "message_message_groups_join" WHERE ("message_message_groups_join".message_id = 22936)
  DayPartMessage Load (1.4ms)   SELECT * FROM "day_part_messages_join" WHERE ("day_part_messages_join".message_id = 22936)
  ItemMessage Load (1.3ms)   SELECT * FROM "item_messages_join" WHERE ("item_messages_join".message_id = 22936)
  MessageGridItem Load (0.8ms)   SELECT * FROM "message_grid_items_join" WHERE ("message_grid_items_join".message_id = 22936)
  MessageTag Load (0.9ms)   SELECT * FROM "message_tags_join" WHERE ("message_tags_join".message_id = 22936)
  MessageItemCategory Load (1.1ms)   SELECT * FROM "message_item_categories_join" WHERE ("message_item_categories_join".message_id = 22936)
  MessageStringValue Load (1.0ms)   SELECT * FROM "message_string_values" WHERE ("message_string_values".message_id = 22936)
  SQL (0.2ms)   BEGIN
  Message Load (0.5ms)   SELECT "messages".id FROM "messages" WHERE ("messages"."name" = '3 Regular Footlong Subs for 14.99 [after 4PM & Weekends]' AND "messages"."entity_id" = 140 AND "messages".id <> 22936) LIMIT 1
POS
  SQL (6.8ms)   SELECT count(*) AS count_all FROM "devices" WHERE ("devices".header_id = 22936)
  SQL (3.5ms)   SELECT count(*) AS count_all FROM "devices" WHERE ("devices".footer_id = 22936)
  Entity Load (1.0ms)   SELECT * FROM "entities" WHERE (("entities".id != 140) AND ("entities"."lft" <= 318 AND "entities"."rgt" >= 20709)) ORDER BY "lft"
  StringValue Load (0.8ms)   SELECT * FROM "string_values" WHERE ("string_values"."id" IN (NULL)) AND ("string_values"."entity_id" IN (1,140))
TEXT VALUES: []
  CACHE (0.0ms)   SELECT * FROM "entities" WHERE (("entities".id != 140) AND ("entities"."lft" <= 318 AND "entities"."rgt" >= 20709)) ORDER BY "lft"
  Message Load Including Associations (1.4ms)   SELECT "messages"."id" AS t0_r0, "messages"."name" AS t0_r1, "messages"."message_type_id" AS t0_r2, "messages"."text" AS t0_r3, "messages"."font_size" AS t0_r4, "messages"."frame" AS t0_r5, "messages"."image_id" AS t0_r6, "messages"."grid_type_id" AS t0_r7, "messages"."image_placement" AS t0_r8, "messages"."answer" AS t0_r9, "messages"."answer_inverted" AS t0_r10, "messages"."day_part_id" AS t0_r11, "messages"."nutrient_range" AS t0_r12, "messages"."nutritional_category_id" AS t0_r13, "messages"."min" AS t0_r14, "messages"."max" AS t0_r15, "messages"."entity_id" AS t0_r16, "messages"."created_by" AS t0_r17, "messages"."create_method" AS t0_r18, "messages"."created_on" AS t0_r19, "messages"."modified_by" AS t0_r20, "messages"."updated_on" AS t0_r21, "messages"."activate_at" AS t0_r22, "messages"."status_id" AS t0_r23, "messages"."version_id" AS t0_r24, "messages"."pos_id" AS t0_r25, "messages"."include_pool" AS t0_r26, "messages"."grid_format" AS t0_r27, "messages"."include_info" AS t0_r28, "messages"."embedded_text" AS t0_r29, "messages"."duration_unit" AS t0_r30, "messages"."duration" AS t0_r31, "messages"."duration_round" AS t0_r32, "messages"."game_freq" AS t0_r33, "messages"."info" AS t0_r34, "messages"."start_offset" AS t0_r35, "messages"."value" AS t0_r36, "messages"."cost" AS t0_r37, "messages"."priority" AS t0_r38, "messages"."optional" AS t0_r39, "messages"."barcode_format_id" AS t0_r40, "messages"."barcode_placement" AS t0_r41, "messages"."barcode_height" AS t0_r42, "messages"."barcode_print_string" AS t0_r43, "messages"."barcode_string" AS t0_r44, "messages"."embedded_text_2" AS t0_r45, "messages"."redeem_suppress" AS t0_r46, "messages"."state" AS t0_r47, "messages"."plain_text" AS t0_r48, "messages"."start_date" AS t0_r49, "messages"."end_date" AS t0_r50, "entities"."id" AS t1_r0, "entities"."entity_type_id" AS t1_r1, "entities"."name" AS t1_r2, "entities"."info" AS t1_r3, "entities"."enterprise" AS t1_r4, "entities"."lft" AS t1_r5, "entities"."rgt" AS t1_r6, "entities"."parent_id" AS t1_r7, "entities"."signature" AS t1_r8, "entities"."segment_type_id" AS t1_r9, "entities"."created_by" AS t1_r10, "entities"."create_method" AS t1_r11, "entities"."created_on" AS t1_r12, "entities"."modified_by" AS t1_r13, "entities"."updated_on" AS t1_r14, "entities"."update_sw_version" AS t1_r15, "entities"."store_number" AS t1_r16, "entities"."billing_status" AS t1_r17, "entities"."sign_up_date" AS t1_r18, "entities"."paid_date" AS t1_r19, "entities"."paid_through_date" AS t1_r20, "entities"."active_date" AS t1_r21, "entities"."cancel_date" AS t1_r22, "entities"."payment_method" AS t1_r23, "entities"."billing_interval" AS t1_r24, "entities"."fees_upfront" AS t1_r25, "entities"."fees_ongoing" AS t1_r26, "entities"."contact_name" AS t1_r27, "entities"."contact_email" AS t1_r28, "entities"."contact_phone" AS t1_r29, "entities"."street_address" AS t1_r30, "entities"."city" AS t1_r31, "entities"."state" AS t1_r32, "entities"."zipcode" AS t1_r33, "entities"."status" AS t1_r34, "entities"."cancel_reason" AS t1_r35, "entities"."account_number" AS t1_r36, "entities"."has_components" AS t1_r37, "entities"."lat" AS t1_r38, "entities"."lng" AS t1_r39, "entities"."street_address_2" AS t1_r40, "string_values"."id" AS t2_r0, "string_values"."string_type_id" AS t2_r1, "string_values"."name" AS t2_r2, "string_values"."entity_id" AS t2_r3, "string_values"."pos_profile_id" AS t2_r4, "string_values"."updated_on" AS t2_r5, "string_values"."modified_by" AS t2_r6, "string_values"."created_on" AS t2_r7, "string_values"."created_by" AS t2_r8, "string_values"."create_method" AS t2_r9 FROM "messages" LEFT OUTER JOIN "entities" ON "entities".id = "messages".entity_id LEFT OUTER JOIN "message_string_values" ON ("messages"."id" = "message_string_values"."message_id") LEFT OUTER JOIN "string_values" ON ("string_values"."id" = "message_string_values"."string_value_id") WHERE (string_values.name IN (NULL) AND messages.id != 22936) AND (((entities.lft>=318 AND entities.rgt<20709) OR entities.id IN (1,140)) AND (messages.state in (0)))
CONFLICTS: []
  Message Update (0.9ms)   UPDATE "messages" SET "modified_by" = 1788, "optional" = 'f', "updated_on" = '2013-09-24 23:51:05.333942' WHERE "id" = 22936
  SQL (0.7ms)   INSERT INTO "change_history" ("element_type", "name", "entity_id", "change_type", "record_type_id", "details", "user_id", "element_id", "updated_on") VALUES('Message', '3 Regular Footlong Subs for 14.99 [after 4PM & Weekends]', 140, 'edit', 1, '---
optional:
- true
- false
modified_by:
- 249
- 1788
updated_on:
- 2013-09-04 00:18:17.502932 Z
- 2013-09-24 23:51:05.333942 Z
', 1788, 22936, '2013-09-24 23:51:05.375629') RETURNING "id"
OPTIONAL WAS: true IS: false
  SQL (1.8ms)   COMMIT
ELAPSED: 0.596269
Redirected to http://33.33.33.10:3000/messages/list?context_filter=current_context&group=8
Completed in 1317ms (DB: 38) | 302 Found [http://33.33.33.10/messages/22936?group=8]
  SQL (0.3ms)   SET client_min_messages TO 'panic'
  SQL (0.3ms)   SET standard_conforming_strings = on
  SQL (0.2ms)   SET client_min_messages TO 'notice'


Processing MessagesController#list (for 33.33.33.1 at 2013-09-24 16:51:05) [GET]
  Parameters: {"group"=>"8", "controller"=>"messages", "context_filter"=>"current_context", "action"=>"list"}
  User Load (0.8ms)   SELECT * FROM "users" WHERE ("users"."id" = 1788)
  Role Load (0.9ms)   SELECT * FROM "roles" WHERE ("roles"."id" = 1)
  RolePerm Load (1.0ms)   SELECT "role_perms".* FROM "role_perms" WHERE ("role_perms".role_id = 1)
  Perm Load (1.2ms)   SELECT * FROM "perms" WHERE ("perms"."id" IN (75,1,27,52,62,9,37,14,72,24,47,82,6,57,34,11,21,67,19,44,77,3,29,54,31,39,64,16,41,74,26,51,49,84,8,59,36,61,13,71,69,23,46,81,79,5,56,33,10,20,66,18,43,76,2,28,53,30,38,63,15,40,73,25,50,48,83,7,58,35,60,12,70,68,22,45,80,78,4,55,32,65,17,42))
  Entity Load (1.4ms)   SELECT * FROM "entities" WHERE ("entities"."id" = 140)
SETTING UP CURRENT VARS. CU: 1788 CEX: 140
GETTING SESSION APPS: {"enhanced"=>140, "employee_messages"=>140, "coupon"=>140, "game"=>140, "basic"=>140}
  Timezone Load (0.6ms)   SELECT * FROM "timezones" WHERE ("timezones"."id" = 6)
  Entity Load (0.9ms)   SELECT * FROM "entities" WHERE (("entities".id != 140) AND ("entities"."lft" <= 318 AND "entities"."rgt" >= 20709)) ORDER BY "lft"
  Bulletin Load Including Associations (2.6ms)   SELECT "bulletins"."id" AS t0_r0, "bulletins"."entity_id" AS t0_r1, "bulletins"."name" AS t0_r2, "bulletins"."body" AS t0_r3, "bulletins"."url" AS t0_r4, "bulletins"."start_date" AS t0_r5, "bulletins"."end_date" AS t0_r6, "bulletins"."created_by" AS t0_r7, "bulletins"."created_on" AS t0_r8, "bulletins"."updated_on" AS t0_r9, "bulletins"."modified_by" AS t0_r10, "bulletins"."queue_email" AS t0_r11, "bulletins"."last_emailed_on" AS t0_r12, "bulletins"."send_to_users" AS t0_r13, "bulletins"."send_to_account_contacts" AS t0_r14, "user_bulletins"."id" AS t1_r0, "user_bulletins"."bulletin_id" AS t1_r1, "user_bulletins"."user_id" AS t1_r2, "bulletin_entities_join"."id" AS t2_r0, "bulletin_entities_join"."entity_id" AS t2_r1, "bulletin_entities_join"."bulletin_id" AS t2_r2 FROM "bulletins" LEFT OUTER JOIN "user_bulletins" ON user_bulletins.bulletin_id = bulletins.id LEFT OUTER JOIN "bulletin_entities_join" ON bulletin_entities_join.bulletin_id = bulletins.id WHERE (bulletins.start_date <= '2013-09-24 23:51:06.368875' AND (bulletins.end_date > '2013-09-24 23:51:06.368879' OR bulletins.end_date IS NULL) AND user_bulletins.user_id = 1788 AND bulletin_entities_join.entity_id IN (1,140)) ORDER BY bulletins.start_date DESC
  Bulletin Load Including Associations (0.6ms)   SELECT "bulletins"."id" AS t0_r0, "bulletins"."entity_id" AS t0_r1, "bulletins"."name" AS t0_r2, "bulletins"."body" AS t0_r3, "bulletins"."url" AS t0_r4, "bulletins"."start_date" AS t0_r5, "bulletins"."end_date" AS t0_r6, "bulletins"."created_by" AS t0_r7, "bulletins"."created_on" AS t0_r8, "bulletins"."updated_on" AS t0_r9, "bulletins"."modified_by" AS t0_r10, "bulletins"."queue_email" AS t0_r11, "bulletins"."last_emailed_on" AS t0_r12, "bulletins"."send_to_users" AS t0_r13, "bulletins"."send_to_account_contacts" AS t0_r14, "bulletin_entities_join"."id" AS t1_r0, "bulletin_entities_join"."entity_id" AS t1_r1, "bulletin_entities_join"."bulletin_id" AS t1_r2 FROM "bulletins" LEFT OUTER JOIN "bulletin_entities_join" ON bulletin_entities_join.bulletin_id = bulletins.id WHERE (bulletins.start_date <= '2013-09-24 23:51:06.378821' AND (bulletins.end_date > '2013-09-24 23:51:06.378825' OR bulletins.end_date IS NULL) AND bulletin_entities_join.entity_id IN (1,140)) ORDER BY bulletins.start_date DESC
BROWSER: Firefox
PARAMS: {"group"=>8, "controller"=>"messages", "rolodex"=>nil, "context_filter"=>"current_context", "action"=>"list", "states"=>[0]}
  Entity Load (0.6ms)   SELECT * FROM "entities" WHERE ("entities"."id" = 1)
  Entity Load (1.3ms)   SELECT "entities".* FROM "entities" INNER JOIN "entity_users_join" ON "entities".id = "entity_users_join".entity_id WHERE (("entity_users_join".user_id = 1788))
GROUP: 8
  Message Load Including Associations (8.7ms)   SELECT "messages"."id" AS t0_r0, "messages"."name" AS t0_r1, "messages"."message_type_id" AS t0_r2, "messages"."text" AS t0_r3, "messages"."font_size" AS t0_r4, "messages"."frame" AS t0_r5, "messages"."image_id" AS t0_r6, "messages"."grid_type_id" AS t0_r7, "messages"."image_placement" AS t0_r8, "messages"."answer" AS t0_r9, "messages"."answer_inverted" AS t0_r10, "messages"."day_part_id" AS t0_r11, "messages"."nutrient_range" AS t0_r12, "messages"."nutritional_category_id" AS t0_r13, "messages"."min" AS t0_r14, "messages"."max" AS t0_r15, "messages"."entity_id" AS t0_r16, "messages"."created_by" AS t0_r17, "messages"."create_method" AS t0_r18, "messages"."created_on" AS t0_r19, "messages"."modified_by" AS t0_r20, "messages"."updated_on" AS t0_r21, "messages"."activate_at" AS t0_r22, "messages"."status_id" AS t0_r23, "messages"."version_id" AS t0_r24, "messages"."pos_id" AS t0_r25, "messages"."include_pool" AS t0_r26, "messages"."grid_format" AS t0_r27, "messages"."include_info" AS t0_r28, "messages"."embedded_text" AS t0_r29, "messages"."duration_unit" AS t0_r30, "messages"."duration" AS t0_r31, "messages"."duration_round" AS t0_r32, "messages"."game_freq" AS t0_r33, "messages"."info" AS t0_r34, "messages"."start_offset" AS t0_r35, "messages"."value" AS t0_r36, "messages"."cost" AS t0_r37, "messages"."priority" AS t0_r38, "messages"."optional" AS t0_r39, "messages"."barcode_format_id" AS t0_r40, "messages"."barcode_placement" AS t0_r41, "messages"."barcode_height" AS t0_r42, "messages"."barcode_print_string" AS t0_r43, "messages"."barcode_string" AS t0_r44, "messages"."embedded_text_2" AS t0_r45, "messages"."redeem_suppress" AS t0_r46, "messages"."state" AS t0_r47, "messages"."plain_text" AS t0_r48, "messages"."start_date" AS t0_r49, "messages"."end_date" AS t0_r50, "message_types"."id" AS t1_r0, "message_types"."name" AS t1_r1, "message_types"."info" AS t1_r2, "message_types"."entity_id" AS t1_r3, "message_types"."image_placement" AS t1_r4, "message_types"."default_rotation_style_id" AS t1_r5, "message_types"."message_type_group_id" AS t1_r6, "message_types"."game_base" AS t1_r7, "message_types"."start_date" AS t1_r8, "message_types"."end_date" AS t1_r9, "message_types"."repeatable" AS t1_r10, "message_types"."image_id" AS t1_r11, "message_types"."frame" AS t1_r12, "message_types"."locked" AS t1_r13, "message_types"."ric_code" AS t1_r14, "message_types"."updated_on" AS t1_r15, "message_types"."modified_by" AS t1_r16, "message_types"."created_on" AS t1_r17, "message_types"."created_by" AS t1_r18, "message_types"."create_method" AS t1_r19, "entities"."id" AS t2_r0, "entities"."entity_type_id" AS t2_r1, "entities"."name" AS t2_r2, "entities"."info" AS t2_r3, "entities"."enterprise" AS t2_r4, "entities"."lft" AS t2_r5, "entities"."rgt" AS t2_r6, "entities"."parent_id" AS t2_r7, "entities"."signature" AS t2_r8, "entities"."segment_type_id" AS t2_r9, "entities"."created_by" AS t2_r10, "entities"."create_method" AS t2_r11, "entities"."created_on" AS t2_r12, "entities"."modified_by" AS t2_r13, "entities"."updated_on" AS t2_r14, "entities"."update_sw_version" AS t2_r15, "entities"."store_number" AS t2_r16, "entities"."billing_status" AS t2_r17, "entities"."sign_up_date" AS t2_r18, "entities"."paid_date" AS t2_r19, "entities"."paid_through_date" AS t2_r20, "entities"."active_date" AS t2_r21, "entities"."cancel_date" AS t2_r22, "entities"."payment_method" AS t2_r23, "entities"."billing_interval" AS t2_r24, "entities"."fees_upfront" AS t2_r25, "entities"."fees_ongoing" AS t2_r26, "entities"."contact_name" AS t2_r27, "entities"."contact_email" AS t2_r28, "entities"."contact_phone" AS t2_r29, "entities"."street_address" AS t2_r30, "entities"."city" AS t2_r31, "entities"."state" AS t2_r32, "entities"."zipcode" AS t2_r33, "entities"."status" AS t2_r34, "entities"."cancel_reason" AS t2_r35, "entities"."account_number" AS t2_r36, "entities"."has_components" AS t2_r37, "entities"."lat" AS t2_r38, "entities"."lng" AS t2_r39, "entities"."street_address_2" AS t2_r40, "message_images"."id" AS t3_r0, "message_images"."name" AS t3_r1, "message_images"."name_on_disk" AS t3_r2, "message_images"."entity_id" AS t3_r3, "message_images"."created_by" AS t3_r4, "message_images"."create_method" AS t3_r5, "message_images"."created_on" AS t3_r6, "message_images"."modified_by" AS t3_r7, "message_images"."updated_on" AS t3_r8, "message_images"."activate_at" AS t3_r9, "message_images"."version_id" AS t3_r10, "message_images"."status_id" AS t3_r11, "message_images"."image_type_id" AS t3_r12, "message_images"."text_coord_x" AS t3_r13, "message_images"."text_coord_y" AS t3_r14, "message_images"."text_width" AS t3_r15, "message_images"."text_height" AS t3_r16, "message_images"."include_text" AS t3_r17, "message_images"."message_type_group_id" AS t3_r18, "message_images"."include_secondary_text" AS t3_r19, "message_images"."secondary_text_width" AS t3_r20, "message_images"."secondary_text_height" AS t3_r21, "message_images"."secondary_text_coord_x" AS t3_r22, "message_images"."secondary_text_coord_y" AS t3_r23 FROM "messages" LEFT OUTER JOIN "message_types" ON "message_types".id = "messages".message_type_id LEFT OUTER JOIN "entities" ON "entities".id = "messages".entity_id LEFT OUTER JOIN "message_images" ON "message_images".id = "messages".image_id WHERE (1=1) AND ((((entities.id = 140) AND (messages.state in (0))) AND (message_types.message_type_group_id = 8)) AND (message_types.message_type_group_id NOT IN (2,4,7))) ORDER BY lower("messages"."name") asc LIMIT 25 OFFSET 0
  SQL (1.6ms)   SELECT count(DISTINCT "messages".id) AS count_all FROM "messages" LEFT OUTER JOIN "message_types" ON "message_types".id = "messages".message_type_id LEFT OUTER JOIN "entities" ON "entities".id = "messages".entity_id LEFT OUTER JOIN "message_images" ON "message_images".id = "messages".image_id WHERE (1=1) AND ((((entities.id = 140) AND (messages.state in (0))) AND (message_types.message_type_group_id = 8)) AND (message_types.message_type_group_id NOT IN (2,4,7)))
  CACHE (0.0ms)   SELECT * FROM "entities" WHERE (("entities".id != 140) AND ("entities"."lft" <= 318 AND "entities"."rgt" >= 20709)) ORDER BY "lft"
  Tag Load Including Associations (1.9ms)   SELECT "tags"."id" AS t0_r0, "tags"."name" AS t0_r1, "tags"."info" AS t0_r2, "tags"."entity_id" AS t0_r3, "tags"."created_by" AS t0_r4, "tags"."create_method" AS t0_r5, "tags"."created_on" AS t0_r6, "tags"."modified_by" AS t0_r7, "tags"."updated_on" AS t0_r8, "tags"."version_id" AS t0_r9, "tags"."status_id" AS t0_r10, "tags"."message_image_id" AS t0_r11, "entities"."id" AS t1_r0, "entities"."entity_type_id" AS t1_r1, "entities"."name" AS t1_r2, "entities"."info" AS t1_r3, "entities"."enterprise" AS t1_r4, "entities"."lft" AS t1_r5, "entities"."rgt" AS t1_r6, "entities"."parent_id" AS t1_r7, "entities"."signature" AS t1_r8, "entities"."segment_type_id" AS t1_r9, "entities"."created_by" AS t1_r10, "entities"."create_method" AS t1_r11, "entities"."created_on" AS t1_r12, "entities"."modified_by" AS t1_r13, "entities"."updated_on" AS t1_r14, "entities"."update_sw_version" AS t1_r15, "entities"."store_number" AS t1_r16, "entities"."billing_status" AS t1_r17, "entities"."sign_up_date" AS t1_r18, "entities"."paid_date" AS t1_r19, "entities"."paid_through_date" AS t1_r20, "entities"."active_date" AS t1_r21, "entities"."cancel_date" AS t1_r22, "entities"."payment_method" AS t1_r23, "entities"."billing_interval" AS t1_r24, "entities"."fees_upfront" AS t1_r25, "entities"."fees_ongoing" AS t1_r26, "entities"."contact_name" AS t1_r27, "entities"."contact_email" AS t1_r28, "entities"."contact_phone" AS t1_r29, "entities"."street_address" AS t1_r30, "entities"."city" AS t1_r31, "entities"."state" AS t1_r32, "entities"."zipcode" AS t1_r33, "entities"."status" AS t1_r34, "entities"."cancel_reason" AS t1_r35, "entities"."account_number" AS t1_r36, "entities"."has_components" AS t1_r37, "entities"."lat" AS t1_r38, "entities"."lng" AS t1_r39, "entities"."street_address_2" AS t1_r40 FROM "tags" LEFT OUTER JOIN "entities" ON "entities".id = "tags".entity_id WHERE ((entities.lft>=318 AND entities.rgt<20709) OR entities.id IN (1,140))
GROUP: 8
  MessageType Load Including Associations (2.1ms)   SELECT "message_types"."id" AS t0_r0, "message_types"."name" AS t0_r1, "message_types"."info" AS t0_r2, "message_types"."entity_id" AS t0_r3, "message_types"."image_placement" AS t0_r4, "message_types"."default_rotation_style_id" AS t0_r5, "message_types"."message_type_group_id" AS t0_r6, "message_types"."game_base" AS t0_r7, "message_types"."start_date" AS t0_r8, "message_types"."end_date" AS t0_r9, "message_types"."repeatable" AS t0_r10, "message_types"."image_id" AS t0_r11, "message_types"."frame" AS t0_r12, "message_types"."locked" AS t0_r13, "message_types"."ric_code" AS t0_r14, "message_types"."updated_on" AS t0_r15, "message_types"."modified_by" AS t0_r16, "message_types"."created_on" AS t0_r17, "message_types"."created_by" AS t0_r18, "message_types"."create_method" AS t0_r19, "entities"."id" AS t1_r0, "entities"."entity_type_id" AS t1_r1, "entities"."name" AS t1_r2, "entities"."info" AS t1_r3, "entities"."enterprise" AS t1_r4, "entities"."lft" AS t1_r5, "entities"."rgt" AS t1_r6, "entities"."parent_id" AS t1_r7, "entities"."signature" AS t1_r8, "entities"."segment_type_id" AS t1_r9, "entities"."created_by" AS t1_r10, "entities"."create_method" AS t1_r11, "entities"."created_on" AS t1_r12, "entities"."modified_by" AS t1_r13, "entities"."updated_on" AS t1_r14, "entities"."update_sw_version" AS t1_r15, "entities"."store_number" AS t1_r16, "entities"."billing_status" AS t1_r17, "entities"."sign_up_date" AS t1_r18, "entities"."paid_date" AS t1_r19, "entities"."paid_through_date" AS t1_r20, "entities"."active_date" AS t1_r21, "entities"."cancel_date" AS t1_r22, "entities"."payment_method" AS t1_r23, "entities"."billing_interval" AS t1_r24, "entities"."fees_upfront" AS t1_r25, "entities"."fees_ongoing" AS t1_r26, "entities"."contact_name" AS t1_r27, "entities"."contact_email" AS t1_r28, "entities"."contact_phone" AS t1_r29, "entities"."street_address" AS t1_r30, "entities"."city" AS t1_r31, "entities"."state" AS t1_r32, "entities"."zipcode" AS t1_r33, "entities"."status" AS t1_r34, "entities"."cancel_reason" AS t1_r35, "entities"."account_number" AS t1_r36, "entities"."has_components" AS t1_r37, "entities"."lat" AS t1_r38, "entities"."lng" AS t1_r39, "entities"."street_address_2" AS t1_r40, "message_type_groups"."id" AS t2_r0, "message_type_groups"."name" AS t2_r1, "message_type_groups"."fixed" AS t2_r2, "message_type_groups"."ric_code" AS t2_r3 FROM "message_types" LEFT OUTER JOIN "entities" ON "entities".id = "message_types".entity_id LEFT OUTER JOIN "message_type_groups" ON "message_type_groups".id = "message_types".message_type_group_id WHERE ((((message_types.message_type_group_id = 8) AND (message_types.message_type_group_id NOT IN (2,4,7))) AND (( locked='f' and message_types.entity_id != 140 ) or ( message_types.entity_id = 140))) AND (entities.id=140 or (entities.lft>=318 and entities.rgt<20709) or entities.id in (1))) ORDER BY message_types.name
Set FILTER SELECTIONS HASH {"period_key"=>nil, "context_filter"=>"current_context", "states"=>[0], "tag_ids"=>nil}
Rendering template within layouts/application
Rendering messages/list
Rendered shared/_flash_disappearing (0.5ms)
Rendered queries/_full_text_search (1.6ms)
Rendered queries/_form (2.4ms)
Rendered queries/_form (1.9ms)
Rendered queries/_query_options_utility (10.6ms)
Rendered queries/_hidden_fields (0.4ms)