gistfile1.txt

Processing MessagesController#update (for 33.33.33.1 at 2013-09-25 12:24:13) [PUT]
  Parameters: {"group"=>"8", "message"=>{"end_date"=>"", "value"=>"", "priority"=>"3", "pos_id"=>"", "name"=>"10% Off Any Catering Order Over $50", "start_offset"=>"1", "frame"=>"0", "barcode_print_string"=>"0", "image_placement"=>"1", "barcode_string"=>"", "barcode_placement"=>"1", "include_barcode"=>"0", "duration"=>"30", "image_id"=>"2055", "text"=>"", "redeem_suppress"=>"0", "duration_round"=>"None", "answer"=>"", "include_pool"=>"1", "include_info"=>"0", "duration_unit"=>"Days", "dynamic_date"=>"1", "answer_inverted"=>"0", "info"=>"", "embedded_text"=>"<p>{{beg_date}} - {{exp_date}}</p>", "include_answer"=>"0", "optional"=>"0", "embedded_text_2"=>"<p>{{receipt.header_address1}}</p>", "message_type_id"=>"4", "barcode_height"=>"24", "start_date"=>"", "string_rules_attributes"=>{"0"=>{"string_type"=>"", "comparison"=>"between", "max_value"=>"", "min_value"=>"", "string_value_id"=>"", "printable"=>"0"}}, "cost"=>"", "barcode_format_id"=>"1", "state"=>"0"}, "search"=>{"search_name"=>""}, "controller"=>"messages", "id"=>"22891", "authenticity_token"=>"BimnFhHmFsZljlq3cvsCYAcyQCTfuvGGhIWLdwkYZGk=", "string_value"=>{"name"=>"", "pos_profile_id"=>"5"}, "action"=>"update", "commit"=>{"pinned"=>"save", "type"=>"save"}, "_method"=>"put", "message_string_value_ids"=>[""]}
  User Load (1.7ms)   SELECT * FROM "users" WHERE ("users"."id" = 1788)
  Role Load (1.0ms)   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 (2.0ms)   SELECT * FROM "perms" WHERE ("perms"."id" IN (23,64,41,74,5,33,49,10,51,84,20,61,18,59,71,69,28,2,30,46,81,79,38,15,56,25,66,43,76,7,35,12,53,22,63,40,73,4,32,48,50,83,60,17,58,70,68,27,1,45,80,78,9,37,14,55,24,65,42,75,6,34,11,52,62,21,19,72,29,3,31,47,82,39,16,57,26,67,44,77,8,36,13,54))
  Entity Load (1.1ms)   SELECT * FROM "entities" WHERE ("entities"."id" = 1)
SETTING UP CURRENT VARS. CU: 1788 CEX: 1
GETTING SESSION APPS: {"enhanced"=>1, "mobile_offers"=>1, "coupon"=>1, "nutrition"=>1, "game"=>1, "basic"=>1, "content"=>1, "survey"=>1, "employee_messages"=>1, :sys_admin=>1, "cycle"=>1}
  Timezone Load (0.8ms)   SELECT * FROM "timezones" WHERE ("timezones"."id" = 6)
BROWSER: Firefox
  Message Load Including Associations (4.5ms)   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" = 22891) AND (entities.id=1 or (entities.lft>=1 and entities.rgt<21529) )
ELAPSED: 0.038902
  MessageMessageGroup Load (1.0ms)   SELECT * FROM "message_message_groups_join" WHERE ("message_message_groups_join".message_id = 22891)
  DayPartMessage Load (1.7ms)   SELECT * FROM "day_part_messages_join" WHERE ("day_part_messages_join".message_id = 22891)
  ItemMessage Load (1.1ms)   SELECT * FROM "item_messages_join" WHERE ("item_messages_join".message_id = 22891)
  MessageGridItem Load (0.7ms)   SELECT * FROM "message_grid_items_join" WHERE ("message_grid_items_join".message_id = 22891)
  MessageTag Load (1.0ms)   SELECT * FROM "message_tags_join" WHERE ("message_tags_join".message_id = 22891)
  MessageItemCategory Load (1.8ms)   SELECT * FROM "message_item_categories_join" WHERE ("message_item_categories_join".message_id = 22891)
  MessageStringValue Load (0.9ms)   SELECT * FROM "message_string_values" WHERE ("message_string_values".message_id = 22891)
  SQL (0.2ms)   BEGIN
  Message Load (7.8ms)   SELECT "messages".id FROM "messages" WHERE ("messages"."name" = '10% Off Any Catering Order Over $50' AND "messages"."entity_id" = 9987 AND "messages".id <> 22891) LIMIT 1
POS
  SQL (30.0ms)   SELECT count(*) AS count_all FROM "devices" WHERE ("devices".header_id = 22891)
  SQL (8.3ms)   SELECT count(*) AS count_all FROM "devices" WHERE ("devices".footer_id = 22891)
  Entity Load (1.5ms)   SELECT * FROM "entities" WHERE (("entities".id != 9987) AND ("entities"."lft" <= 21511 AND "entities"."rgt" >= 21522)) ORDER BY "lft"
  StringValue Load (1.0ms)   SELECT * FROM "string_values" WHERE ("string_values"."id" IN (NULL)) AND ("string_values"."entity_id" IN (1,9987))
TEXT VALUES: []
  CACHE (0.0ms)   SELECT * FROM "entities" WHERE (("entities".id != 9987) AND ("entities"."lft" <= 21511 AND "entities"."rgt" >= 21522)) ORDER BY "lft"
  Message Load Including Associations (6.2ms)   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 != 22891) AND (((entities.lft>=21511 AND entities.rgt<21522) OR entities.id IN (1,9987)) AND (messages.state in (0)))
CONFLICTS: []
  Message Update (2.2ms)   UPDATE "messages" SET "modified_by" = 1788, "optional" = 'f', "updated_on" = '2013-09-25 19:24:15.362049' WHERE "id" = 22891
  SQL (6.7ms)   INSERT INTO "change_history" ("element_id", "updated_on", "name", "user_id", "record_type_id", "entity_id", "change_type", "element_type", "details") VALUES(22891, '2013-09-25 19:24:15.421191', '10% Off Any Catering Order Over $50', 1788, 1, 1, 'edit', 'Message', '---
updated_on:
- 2013-06-14 22:28:58.410738 Z
- 2013-09-25 19:24:15.362049 Z
optional:
- true
- false
modified_by:
-
- 1788
') RETURNING "id"
OPTIONAL IS: false WAS: true
  EntityMessage Load (3.1ms)   SELECT * FROM "message_entities_join" WHERE ("message_entities_join".message_id = 22891)
  Entity Load (397.1ms)   SELECT * FROM "entities" WHERE ("entities"."lft" >= 1 AND "entities"."rgt" <= 21529) ORDER BY "lft"
  EntityMessage Destroy (2.2ms)   DELETE FROM "message_entities_join" WHERE "id" = 6477
  Message Load (0.8ms)   SELECT * FROM "messages" WHERE ("messages"."id" = 22891)
  SQL (0.7ms)   INSERT INTO "change_history" ("element_id", "updated_on", "name", "user_id", "record_type_id", "entity_id", "change_type", "element_type", "details") VALUES(6477, '2013-09-25 19:24:32.574677', 'Optional message: 10% Off Any Catering Order Over $50', 1788, 2, 1, 'delete', 'EntityMessage', '---
name:
- "Optional message: 10% Off Any Catering Order Over $50"
-
') RETURNING "id"
  SQL (1.0ms)   COMMIT
ELAPSED: 17.88026
Redirected to http://33.33.33.10:3000/messages?group=8
Completed in 18674ms (DB: 492) | 302 Found [http://33.33.33.10/messages/22891?group=8]
  SQL (0.4ms)   SET client_min_messages TO 'panic'
  SQL (0.4ms)   SET standard_conforming_strings = on
  SQL (0.3ms)   SET client_min_messages TO 'notice'


Processing MessagesController#index (for 33.33.33.1 at 2013-09-25 12:24:32) [GET]
  Parameters: {"group"=>"8", "controller"=>"messages", "action"=>"index"}
  User Load (1.1ms)   SELECT * FROM "users" WHERE ("users"."id" = 1788)
  Role Load (0.7ms)   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.1ms)   SELECT * FROM "perms" WHERE ("perms"."id" IN (23,64,41,74,5,33,49,10,51,84,20,61,18,59,71,69,28,2,30,46,81,79,38,15,56,25,66,43,76,7,35,12,53,22,63,40,73,4,32,48,50,83,60,17,58,70,68,27,1,45,80,78,9,37,14,55,24,65,42,75,6,34,11,52,62,21,19,72,29,3,31,47,82,39,16,57,26,67,44,77,8,36,13,54))
  Entity Load (1.3ms)   SELECT * FROM "entities" WHERE ("entities"."id" = 1)
SETTING UP CURRENT VARS. CU: 1788 CEX: 1
GETTING SESSION APPS: {"enhanced"=>1, "mobile_offers"=>1, "nutrition"=>1, "coupon"=>1, "game"=>1, "content"=>1, "basic"=>1, "survey"=>1, "employee_messages"=>1, "cycle"=>1, :sys_admin=>1}
  Timezone Load (0.6ms)   SELECT * FROM "timezones" WHERE ("timezones"."id" = 6)
  Entity Load (0.9ms)   SELECT * FROM "entities" WHERE (("entities".id != 1) AND ("entities"."lft" <= 1 AND "entities"."rgt" >= 21529)) ORDER BY "lft"
  Bulletin Load Including Associations (1.8ms)   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-25 19:24:33.786758' AND (bulletins.end_date > '2013-09-25 19:24:33.786767' OR bulletins.end_date IS NULL) AND user_bulletins.user_id = 1788 AND bulletin_entities_join.entity_id IN (1)) ORDER BY bulletins.start_date DESC
  Bulletin Load Including Associations (1.1ms)   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-25 19:24:33.798196' AND (bulletins.end_date > '2013-09-25 19:24:33.798199' OR bulletins.end_date IS NULL) AND bulletin_entities_join.entity_id IN (1)) ORDER BY bulletins.start_date DESC
BROWSER: Firefox
PARAMS: {"rolodex"=>nil, "states"=>[0], "group"=>8, "controller"=>"messages", "action"=>"index"}
  Entity Load (2.0ms)   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
  CACHE (0.0ms)   SELECT * FROM "entities" WHERE (("entities".id != 1) AND ("entities"."lft" <= 1 AND "entities"."rgt" >= 21529)) ORDER BY "lft"
  Message Load Including Associations (37.6ms)   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.lft>=1 AND entities.rgt<21529) OR entities.id IN (1)) AND (messages.state in (0))) AND (message_types.message_type_group_id = 8)) ORDER BY lower("messages"."name") asc LIMIT 25 OFFSET 0
  SQL (13.1ms)   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.lft>=1 AND entities.rgt<21529) OR entities.id IN (1)) AND (messages.state in (0))) AND (message_types.message_type_group_id = 8))
  CACHE (0.0ms)   SELECT * FROM "entities" WHERE (("entities".id != 1) AND ("entities"."lft" <= 1 AND "entities"."rgt" >= 21529)) ORDER BY "lft"
  Tag Load Including Associations (3.3ms)   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>=1 AND entities.rgt<21529) OR entities.id IN (1))
GROUP: 8
  MessageType Load Including Associations (4.5ms)   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 (( locked='f' and message_types.entity_id != 1 ) or ( message_types.entity_id = 1))) AND (entities.id=1 or (entities.lft>=1 and entities.rgt<21529) )) ORDER BY message_types.name
Set FILTER SELECTIONS HASH {"states"=>[0], "tag_ids"=>nil, "period_key"=>nil, "context_filter"=>nil}
Rendering template within layouts/application
Rendering messages/list
Rendered shared/_flash_disappearing (0.8ms)
Rendered queries/_full_text_search (2.4ms)
Rendered queries/_form (3.4ms)
Rendered queries/_form (2.6ms)
Rendered queries/_query_options_utility (11.9ms)
Rendered queries/_hidden_fields (0.6ms)
REQUEST URI: /messages?group=8
MULTI FOR tag_ids
SELECTED ARRAY:
REQUEST URI: /messages?group=8
MULTI FOR states
SELECTED ARRAY: 0
Rendered shared/_filters (54.7ms)
Rendered shared/_rolodex (9.0ms)
Rendered messages/_search_results (207.1ms)
YOU FORGOT TO SET @object_apps PERMS FOR THIS OBJECT
  SQL (4.2ms)   SELECT count(*) AS count_all FROM "entities" WHERE ("entities".parent_id = 1)
  CACHE (0.0ms)   SELECT * FROM "entities" WHERE (("entities".id != 1) AND ("entities"."lft" <= 1 AND "entities"."rgt" >= 21529)) ORDER BY "lft"
Rendered shared/_headlines (0.7ms)
Rendered shared/_nav (109.0ms)
Rendered shared/_context_changer (2.3ms)
Completed in 2402ms (View: 546, DB: 78) | 200 OK [http://33.33.33.10/messages?group=8]