gregblake · June 18, 2019 21:31
diff --git a/after_pr_11607.sql b/after_pr_11607.sql
 -- ~14 queries

 Connect::Room Load (1.0ms)  SELECT  `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1
 Connect::RoomMembership Load (1.1ms)  SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976
 (4.4ms)  select user_id, connect_room_id, connect_bookmark_id, broadcaster from connect_room_users where 1=1 and connect_room_id in (1976) UNION ALL select null, id, null, 0 from connect_rooms where private=0 and archived=0 and id not in (select connect_room_id from connect_room_users)
 SQL (1.4ms)  SELECT  DISTINCT `connect_messages`.`id`, connect_messages.created_at AS alias_0 FROM `connect_messages` LEFT OUTER JOIN `connect_message_reactions` ON `connect_message_reactions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_shared_files` ON `connect_message_shared_files`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_mentions` ON `connect_message_mentions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `users` ON `users`.`id` = `connect_message_mentions`.`user_id` LEFT OUTER JOIN `connect_message_shared_files` `message_shared_files_connect_messages_join` ON `message_shared_files_connect_messages_join`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_shared_files` ON `connect_shared_files`.`id` = `message_shared_files_connect_messages_join`.`connect_shared_file_id` LEFT OUTER JOIN `users` `froms_connect_messages` ON `froms_connect_messages`.`id` = `connect_messages`.`from_id` WHERE `connect_messages`.`to_type` = 'Connect::Room' AND `connect_messages`.`to_id` = 1976 AND (connect_messages.created_at > '2019-06-17 17:26:47') AND (connect_messages.updated_at > '2019-06-18 20:53:31') ORDER BY connect_messages.created_at desc LIMIT 25 OFFSET 0
 SQL (2.8ms)  SELECT `connect_messages`.`id` AS t0_r0, `connect_messages`.`from_id` AS t0_r1, `connect_messages`.`to_id` AS t0_r2, `connect_messages`.`to_type` AS t0_r3, `connect_messages`.`encrypted_body` AS t0_r4, `connect_messages`.`message_id` AS t0_r5, `connect_messages`.`encrypted_stanza` AS t0_r6, `connect_messages`.`created_at` AS t0_r7, `connect_messages`.`updated_at` AS t0_r8, `connect_message_reactions`.`id` AS t1_r0, `connect_message_reactions`.`connect_message_id` AS t1_r1, `connect_message_reactions`.`user_id` AS t1_r2, `connect_message_reactions`.`reaction` AS t1_r3, `connect_message_reactions`.`created_at` AS t1_r4, `connect_message_reactions`.`updated_at` AS t1_r5, `connect_message_shared_files`.`id` AS t2_r0, `connect_message_shared_files`.`created_at` AS t2_r1, `connect_message_shared_files`.`updated_at` AS t2_r2, `connect_message_shared_files`.`connect_message_id` AS t2_r3, `connect_message_shared_files`.`connect_shared_file_id` AS t2_r4, `connect_message_mentions`.`id` AS t3_r0, `connect_message_mentions`.`created_at` AS t3_r1, `connect_message_mentions`.`updated_at` AS t3_r2, `connect_message_mentions`.`connect_message_id` AS t3_r3, `connect_message_mentions`.`user_id` AS t3_r4, `connect_message_mentions`.`all` AS t3_r5, `users`.`id` AS t4_r0, `users`.`login` AS t4_r1, `users`.`first_name` AS t4_r2, `users`.`last_name` AS t4_r3, `users`.`email` AS t4_r4, `users`.`role_id` AS t4_r5, `users`.`code_name` AS t4_r6, `users`.`active` AS t4_r7, `users`.`created_at` AS t4_r8, `users`.`updated_at` AS t4_r9, `users`.`password_reset_code` AS t4_r10, `users`.`system_name` AS t4_r11, `users`.`starting_sales` AS t4_r12, `users`.`staff_id` AS t4_r13, `users`.`address1` AS t4_r14, `users`.`address2` AS t4_r15, `users`.`city` AS t4_r16, `users`.`state` AS t4_r17, `users`.`zip` AS t4_r18, `users`.`email_alt1` AS t4_r19, `users`.`email_alt2` AS t4_r20, `users`.`day_leads` AS t4_r21, `users`.`current_zip` AS t4_r22, `users`.`current_set_id` AS t4_r23, `users`.`last_location_result` AS t4_r24, `users`.`last_location_update` AS t4_r25, `users`.`leads_run_today` AS t4_r26, `users`.`leads_run_yesterday` AS t4_r27, `users`.`initial_draw` AS t4_r28, `users`.`draw_cap` AS t4_r29, `users`.`territory_id` AS t4_r30, `users`.`branch_id` AS t4_r31, `users`.`is_clocked_out` AS t4_r32, `users`.`clocked_out_note` AS t4_r33, `users`.`clocked_out_at` AS t4_r34, `users`.`prior_sales` AS t4_r35, `users`.`created_lead_sources` AS t4_r36, `users`.`payroll_number` AS t4_r37, `users`.`avatar_file_name` AS t4_r38, `users`.`avatar_updated_at` AS t4_r39, `users`.`department_id` AS t4_r40, `users`.`exclude_from_directory` AS t4_r41, `users`.`office_ext` AS t4_r42, `users`.`encrypted_date_of_birth` AS t4_r43, `users`.`started_on` AS t4_r44, `users`.`hired_on` AS t4_r45, `users`.`term_date` AS t4_r46, `users`.`ten99` AS t4_r47, `users`.`other_territories` AS t4_r48, `users`.`transition_role` AS t4_r49, `users`.`vendor_id` AS t4_r50, `users`.`vendor_employee_code` AS t4_r51, `users`.`beta_flag` AS t4_r52, `users`.`home_tab_url` AS t4_r53, `users`.`voicemail_pin` AS t4_r54, `users`.`phone_mac_address` AS t4_r55, `users`.`dialer_ext` AS t4_r56, `users`.`time_zone` AS t4_r57, `users`.`preferred_name` AS t4_r58, `users`.`nick_name` AS t4_r59, `users`.`middle_name` AS t4_r60, `users`.`lat` AS t4_r61, `users`.`lng` AS t4_r62, `users`.`force_password_change` AS t4_r63, `users`.`encrypted_ssn` AS t4_r64, `users`.`title_id` AS t4_r65, `users`.`icewarpsync` AS t4_r66, `users`.`status` AS t4_r67, `users`.`marked_showed_up_on` AS t4_r68, `users`.`created_by_id` AS t4_r69, `users`.`updated_by_id` AS t4_r70, `connect_shared_files`.`id` AS t5_r0, `connect_shared_files`.`created_at` AS t5_r1, `connect_shared_files`.`updated_at` AS t5_r2, `connect_shared_files`.`file_file_name` AS t5_r3, `connect_shared_files`.`file_content_type` AS t5_r4, `connect_shared_files`.`file_file_size` AS t5_r5, `connect_shared_files`.`file_updated_at` AS t5_r6, `connect_shared_files`.`originally_shared_to_id` AS t5_r7, `connect_shared_files`.`originally_shared_to_type` AS t5_r8, `connect_shared_files`.`created_by_id` AS t5_r9, `connect_shared_files`.`lat` AS t5_r10, `connect_shared_files`.`lng` AS t5_r11, `connect_shared_files`.`located_at` AS t5_r12, `connect_shared_files`.`location_description` AS t5_r13, `connect_shared_files`.`device` AS t5_r14, `connect_shared_files`.`location_accuracy` AS t5_r15, `connect_shared_files`.`text_content` AS t5_r16, `connect_shared_files`.`width` AS t5_r17, `connect_shared_files`.`height` AS t5_r18, `connect_shared_files`.`original_file_name` AS t5_r19, `froms_connect_messages`.`id` AS t6_r0, `froms_connect_messages`.`login` AS t6_r1, `froms_connect_messages`.`first_name` AS t6_r2, `froms_connect_messages`.`last_name` AS t6_r3, `froms_connect_messages`.`email` AS t6_r4, `froms_connect_messages`.`role_id` AS t6_r5, `froms_connect_messages`.`code_name` AS t6_r6, `froms_connect_messages`.`active` AS t6_r7, `froms_connect_messages`.`created_at` AS t6_r8, `froms_connect_messages`.`updated_at` AS t6_r9, `froms_connect_messages`.`password_reset_code` AS t6_r10, `froms_connect_messages`.`system_name` AS t6_r11, `froms_connect_messages`.`starting_sales` AS t6_r12, `froms_connect_messages`.`staff_id` AS t6_r13, `froms_connect_messages`.`address1` AS t6_r14, `froms_connect_messages`.`address2` AS t6_r15, `froms_connect_messages`.`city` AS t6_r16, `froms_connect_messages`.`state` AS t6_r17, `froms_connect_messages`.`zip` AS t6_r18, `froms_connect_messages`.`email_alt1` AS t6_r19, `froms_connect_messages`.`email_alt2` AS t6_r20, `froms_connect_messages`.`day_leads` AS t6_r21, `froms_connect_messages`.`current_zip` AS t6_r22, `froms_connect_messages`.`current_set_id` AS t6_r23, `froms_connect_messages`.`last_location_result` AS t6_r24, `froms_connect_messages`.`last_location_update` AS t6_r25, `froms_connect_messages`.`leads_run_today` AS t6_r26, `froms_connect_messages`.`leads_run_yesterday` AS t6_r27, `froms_connect_messages`.`initial_draw` AS t6_r28, `froms_connect_messages`.`draw_cap` AS t6_r29, `froms_connect_messages`.`territory_id` AS t6_r30, `froms_connect_messages`.`branch_id` AS t6_r31, `froms_connect_messages`.`is_clocked_out` AS t6_r32, `froms_connect_messages`.`clocked_out_note` AS t6_r33, `froms_connect_messages`.`clocked_out_at` AS t6_r34, `froms_connect_messages`.`prior_sales` AS t6_r35, `froms_connect_messages`.`created_lead_sources` AS t6_r36, `froms_connect_messages`.`payroll_number` AS t6_r37, `froms_connect_messages`.`avatar_file_name` AS t6_r38, `froms_connect_messages`.`avatar_updated_at` AS t6_r39, `froms_connect_messages`.`department_id` AS t6_r40, `froms_connect_messages`.`exclude_from_directory` AS t6_r41, `froms_connect_messages`.`office_ext` AS t6_r42, `froms_connect_messages`.`encrypted_date_of_birth` AS t6_r43, `froms_connect_messages`.`started_on` AS t6_r44, `froms_connect_messages`.`hired_on` AS t6_r45, `froms_connect_messages`.`term_date` AS t6_r46, `froms_connect_messages`.`ten99` AS t6_r47, `froms_connect_messages`.`other_territories` AS t6_r48, `froms_connect_messages`.`transition_role` AS t6_r49, `froms_connect_messages`.`vendor_id` AS t6_r50, `froms_connect_messages`.`vendor_employee_code` AS t6_r51, `froms_connect_messages`.`beta_flag` AS t6_r52, `froms_connect_messages`.`home_tab_url` AS t6_r53, `froms_connect_messages`.`voicemail_pin` AS t6_r54, `froms_connect_messages`.`phone_mac_address` AS t6_r55, `froms_connect_messages`.`dialer_ext` AS t6_r56, `froms_connect_messages`.`time_zone` AS t6_r57, `froms_connect_messages`.`preferred_name` AS t6_r58, `froms_connect_messages`.`nick_name` AS t6_r59, `froms_connect_messages`.`middle_name` AS t6_r60, `froms_connect_messages`.`lat` AS t6_r61, `froms_connect_messages`.`lng` AS t6_r62, `froms_connect_messages`.`force_password_change` AS t6_r63, `froms_connect_messages`.`encrypted_ssn` AS t6_r64, `froms_connect_messages`.`title_id` AS t6_r65, `froms_connect_messages`.`icewarpsync` AS t6_r66, `froms_connect_messages`.`status` AS t6_r67, `froms_connect_messages`.`marked_showed_up_on` AS t6_r68, `froms_connect_messages`.`created_by_id` AS t6_r69, `froms_connect_messages`.`updated_by_id` AS t6_r70 FROM `connect_messages` LEFT OUTER JOIN `connect_message_reactions` ON `connect_message_reactions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_shared_files` ON `connect_message_shared_files`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_mentions` ON `connect_message_mentions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `users` ON `users`.`id` = `connect_message_mentions`.`user_id` LEFT OUTER JOIN `connect_message_shared_files` `message_shared_files_connect_messages_join` ON `message_shared_files_connect_messages_join`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_shared_files` ON `connect_shared_files`.`id` = `message_shared_files_connect_messages_join`.`connect_shared_file_id` LEFT OUTER JOIN `users` `froms_connect_messages` ON `froms_connect_messages`.`id` = `connect_messages`.`from_id` WHERE `connect_messages`.`to_type` = 'Connect::Room' AND `connect_messages`.`to_id` = 1976 AND (connect_messages.created_at > '2019-06-17 17:26:47') AND (connect_messages.updated_at > '2019-06-18 20:53:31') AND `connect_messages`.`id` IN (41795810, 41795809, 41795808, 41795807, 41795806, 41795805, 41795804, 41795803, 41795802, 41795801, 41795800, 41795799, 41795798, 41795797, 41795796, 41795795, 41795794, 41795793, 41795792, 41795791) ORDER BY connect_messages.created_at desc
 User Load (1.2ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1
 UserTitle Load (1.0ms)  SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201
 Territory Load (1.2ms)  SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1
 Directory::Branch Load (0.8ms)  SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3
 Department Load (1.3ms)  SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20
 Connect::Room Load (1.2ms)  SELECT  `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1
 Connect::RoomMembership Load (1.2ms)  SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE (broadcaster = 1 and user_id is not null) AND `connect_room_memberships`.`connect_room_id` = 1976
 Connect::Bookmark Load (1.2ms)  SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' AND `connect_bookmarks`.`bookmarkable_id` = 1976
 CACHE Connect::RoomMembership Load (0.0ms)  SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976
 CACHE  (0.0ms)  select user_id, connect_room_id, connect_bookmark_id, broadcaster from connect_room_users where 1=1 and connect_room_id in (1976) UNION ALL select null, id, null, 0 from connect_rooms where private=0 and archived=0 and id not in (select connect_room_id from connect_room_users)
 CACHE  (0.0ms)  select user_id, connect_room_id, connect_bookmark_id, broadcaster from connect_room_users where 1=1 and connect_room_id in (1976) UNION ALL select null, id, null, 0 from connect_rooms where private=0 and archived=0 and id not in (select connect_room_id from connect_room_users)
	-- ~14 queries

	Connect::Room Load (1.0ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1
	Connect::RoomMembership Load (1.1ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976
	(4.4ms) select user_id, connect_room_id, connect_bookmark_id, broadcaster from connect_room_users where 1=1 and connect_room_id in (1976) UNION ALL select null, id, null, 0 from connect_rooms where private=0 and archived=0 and id not in (select connect_room_id from connect_room_users)
	SQL (1.4ms) SELECT DISTINCT `connect_messages`.`id`, connect_messages.created_at AS alias_0 FROM `connect_messages` LEFT OUTER JOIN `connect_message_reactions` ON `connect_message_reactions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_shared_files` ON `connect_message_shared_files`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_mentions` ON `connect_message_mentions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `users` ON `users`.`id` = `connect_message_mentions`.`user_id` LEFT OUTER JOIN `connect_message_shared_files` `message_shared_files_connect_messages_join` ON `message_shared_files_connect_messages_join`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_shared_files` ON `connect_shared_files`.`id` = `message_shared_files_connect_messages_join`.`connect_shared_file_id` LEFT OUTER JOIN `users` `froms_connect_messages` ON `froms_connect_messages`.`id` = `connect_messages`.`from_id` WHERE `connect_messages`.`to_type` = 'Connect::Room' AND `connect_messages`.`to_id` = 1976 AND (connect_messages.created_at > '2019-06-17 17:26:47') AND (connect_messages.updated_at > '2019-06-18 20:53:31') ORDER BY connect_messages.created_at desc LIMIT 25 OFFSET 0
	SQL (2.8ms) SELECT `connect_messages`.`id` AS t0_r0, `connect_messages`.`from_id` AS t0_r1, `connect_messages`.`to_id` AS t0_r2, `connect_messages`.`to_type` AS t0_r3, `connect_messages`.`encrypted_body` AS t0_r4, `connect_messages`.`message_id` AS t0_r5, `connect_messages`.`encrypted_stanza` AS t0_r6, `connect_messages`.`created_at` AS t0_r7, `connect_messages`.`updated_at` AS t0_r8, `connect_message_reactions`.`id` AS t1_r0, `connect_message_reactions`.`connect_message_id` AS t1_r1, `connect_message_reactions`.`user_id` AS t1_r2, `connect_message_reactions`.`reaction` AS t1_r3, `connect_message_reactions`.`created_at` AS t1_r4, `connect_message_reactions`.`updated_at` AS t1_r5, `connect_message_shared_files`.`id` AS t2_r0, `connect_message_shared_files`.`created_at` AS t2_r1, `connect_message_shared_files`.`updated_at` AS t2_r2, `connect_message_shared_files`.`connect_message_id` AS t2_r3, `connect_message_shared_files`.`connect_shared_file_id` AS t2_r4, `connect_message_mentions`.`id` AS t3_r0, `connect_message_mentions`.`created_at` AS t3_r1, `connect_message_mentions`.`updated_at` AS t3_r2, `connect_message_mentions`.`connect_message_id` AS t3_r3, `connect_message_mentions`.`user_id` AS t3_r4, `connect_message_mentions`.`all` AS t3_r5, `users`.`id` AS t4_r0, `users`.`login` AS t4_r1, `users`.`first_name` AS t4_r2, `users`.`last_name` AS t4_r3, `users`.`email` AS t4_r4, `users`.`role_id` AS t4_r5, `users`.`code_name` AS t4_r6, `users`.`active` AS t4_r7, `users`.`created_at` AS t4_r8, `users`.`updated_at` AS t4_r9, `users`.`password_reset_code` AS t4_r10, `users`.`system_name` AS t4_r11, `users`.`starting_sales` AS t4_r12, `users`.`staff_id` AS t4_r13, `users`.`address1` AS t4_r14, `users`.`address2` AS t4_r15, `users`.`city` AS t4_r16, `users`.`state` AS t4_r17, `users`.`zip` AS t4_r18, `users`.`email_alt1` AS t4_r19, `users`.`email_alt2` AS t4_r20, `users`.`day_leads` AS t4_r21, `users`.`current_zip` AS t4_r22, `users`.`current_set_id` AS t4_r23, `users`.`last_location_result` AS t4_r24, `users`.`last_location_update` AS t4_r25, `users`.`leads_run_today` AS t4_r26, `users`.`leads_run_yesterday` AS t4_r27, `users`.`initial_draw` AS t4_r28, `users`.`draw_cap` AS t4_r29, `users`.`territory_id` AS t4_r30, `users`.`branch_id` AS t4_r31, `users`.`is_clocked_out` AS t4_r32, `users`.`clocked_out_note` AS t4_r33, `users`.`clocked_out_at` AS t4_r34, `users`.`prior_sales` AS t4_r35, `users`.`created_lead_sources` AS t4_r36, `users`.`payroll_number` AS t4_r37, `users`.`avatar_file_name` AS t4_r38, `users`.`avatar_updated_at` AS t4_r39, `users`.`department_id` AS t4_r40, `users`.`exclude_from_directory` AS t4_r41, `users`.`office_ext` AS t4_r42, `users`.`encrypted_date_of_birth` AS t4_r43, `users`.`started_on` AS t4_r44, `users`.`hired_on` AS t4_r45, `users`.`term_date` AS t4_r46, `users`.`ten99` AS t4_r47, `users`.`other_territories` AS t4_r48, `users`.`transition_role` AS t4_r49, `users`.`vendor_id` AS t4_r50, `users`.`vendor_employee_code` AS t4_r51, `users`.`beta_flag` AS t4_r52, `users`.`home_tab_url` AS t4_r53, `users`.`voicemail_pin` AS t4_r54, `users`.`phone_mac_address` AS t4_r55, `users`.`dialer_ext` AS t4_r56, `users`.`time_zone` AS t4_r57, `users`.`preferred_name` AS t4_r58, `users`.`nick_name` AS t4_r59, `users`.`middle_name` AS t4_r60, `users`.`lat` AS t4_r61, `users`.`lng` AS t4_r62, `users`.`force_password_change` AS t4_r63, `users`.`encrypted_ssn` AS t4_r64, `users`.`title_id` AS t4_r65, `users`.`icewarpsync` AS t4_r66, `users`.`status` AS t4_r67, `users`.`marked_showed_up_on` AS t4_r68, `users`.`created_by_id` AS t4_r69, `users`.`updated_by_id` AS t4_r70, `connect_shared_files`.`id` AS t5_r0, `connect_shared_files`.`created_at` AS t5_r1, `connect_shared_files`.`updated_at` AS t5_r2, `connect_shared_files`.`file_file_name` AS t5_r3, `connect_shared_files`.`file_content_type` AS t5_r4, `connect_shared_files`.`file_file_size` AS t5_r5, `connect_shared_files`.`file_updated_at` AS t5_r6, `connect_shared_files`.`originally_shared_to_id` AS t5_r7, `connect_shared_files`.`originally_shared_to_type` AS t5_r8, `connect_shared_files`.`created_by_id` AS t5_r9, `connect_shared_files`.`lat` AS t5_r10, `connect_shared_files`.`lng` AS t5_r11, `connect_shared_files`.`located_at` AS t5_r12, `connect_shared_files`.`location_description` AS t5_r13, `connect_shared_files`.`device` AS t5_r14, `connect_shared_files`.`location_accuracy` AS t5_r15, `connect_shared_files`.`text_content` AS t5_r16, `connect_shared_files`.`width` AS t5_r17, `connect_shared_files`.`height` AS t5_r18, `connect_shared_files`.`original_file_name` AS t5_r19, `froms_connect_messages`.`id` AS t6_r0, `froms_connect_messages`.`login` AS t6_r1, `froms_connect_messages`.`first_name` AS t6_r2, `froms_connect_messages`.`last_name` AS t6_r3, `froms_connect_messages`.`email` AS t6_r4, `froms_connect_messages`.`role_id` AS t6_r5, `froms_connect_messages`.`code_name` AS t6_r6, `froms_connect_messages`.`active` AS t6_r7, `froms_connect_messages`.`created_at` AS t6_r8, `froms_connect_messages`.`updated_at` AS t6_r9, `froms_connect_messages`.`password_reset_code` AS t6_r10, `froms_connect_messages`.`system_name` AS t6_r11, `froms_connect_messages`.`starting_sales` AS t6_r12, `froms_connect_messages`.`staff_id` AS t6_r13, `froms_connect_messages`.`address1` AS t6_r14, `froms_connect_messages`.`address2` AS t6_r15, `froms_connect_messages`.`city` AS t6_r16, `froms_connect_messages`.`state` AS t6_r17, `froms_connect_messages`.`zip` AS t6_r18, `froms_connect_messages`.`email_alt1` AS t6_r19, `froms_connect_messages`.`email_alt2` AS t6_r20, `froms_connect_messages`.`day_leads` AS t6_r21, `froms_connect_messages`.`current_zip` AS t6_r22, `froms_connect_messages`.`current_set_id` AS t6_r23, `froms_connect_messages`.`last_location_result` AS t6_r24, `froms_connect_messages`.`last_location_update` AS t6_r25, `froms_connect_messages`.`leads_run_today` AS t6_r26, `froms_connect_messages`.`leads_run_yesterday` AS t6_r27, `froms_connect_messages`.`initial_draw` AS t6_r28, `froms_connect_messages`.`draw_cap` AS t6_r29, `froms_connect_messages`.`territory_id` AS t6_r30, `froms_connect_messages`.`branch_id` AS t6_r31, `froms_connect_messages`.`is_clocked_out` AS t6_r32, `froms_connect_messages`.`clocked_out_note` AS t6_r33, `froms_connect_messages`.`clocked_out_at` AS t6_r34, `froms_connect_messages`.`prior_sales` AS t6_r35, `froms_connect_messages`.`created_lead_sources` AS t6_r36, `froms_connect_messages`.`payroll_number` AS t6_r37, `froms_connect_messages`.`avatar_file_name` AS t6_r38, `froms_connect_messages`.`avatar_updated_at` AS t6_r39, `froms_connect_messages`.`department_id` AS t6_r40, `froms_connect_messages`.`exclude_from_directory` AS t6_r41, `froms_connect_messages`.`office_ext` AS t6_r42, `froms_connect_messages`.`encrypted_date_of_birth` AS t6_r43, `froms_connect_messages`.`started_on` AS t6_r44, `froms_connect_messages`.`hired_on` AS t6_r45, `froms_connect_messages`.`term_date` AS t6_r46, `froms_connect_messages`.`ten99` AS t6_r47, `froms_connect_messages`.`other_territories` AS t6_r48, `froms_connect_messages`.`transition_role` AS t6_r49, `froms_connect_messages`.`vendor_id` AS t6_r50, `froms_connect_messages`.`vendor_employee_code` AS t6_r51, `froms_connect_messages`.`beta_flag` AS t6_r52, `froms_connect_messages`.`home_tab_url` AS t6_r53, `froms_connect_messages`.`voicemail_pin` AS t6_r54, `froms_connect_messages`.`phone_mac_address` AS t6_r55, `froms_connect_messages`.`dialer_ext` AS t6_r56, `froms_connect_messages`.`time_zone` AS t6_r57, `froms_connect_messages`.`preferred_name` AS t6_r58, `froms_connect_messages`.`nick_name` AS t6_r59, `froms_connect_messages`.`middle_name` AS t6_r60, `froms_connect_messages`.`lat` AS t6_r61, `froms_connect_messages`.`lng` AS t6_r62, `froms_connect_messages`.`force_password_change` AS t6_r63, `froms_connect_messages`.`encrypted_ssn` AS t6_r64, `froms_connect_messages`.`title_id` AS t6_r65, `froms_connect_messages`.`icewarpsync` AS t6_r66, `froms_connect_messages`.`status` AS t6_r67, `froms_connect_messages`.`marked_showed_up_on` AS t6_r68, `froms_connect_messages`.`created_by_id` AS t6_r69, `froms_connect_messages`.`updated_by_id` AS t6_r70 FROM `connect_messages` LEFT OUTER JOIN `connect_message_reactions` ON `connect_message_reactions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_shared_files` ON `connect_message_shared_files`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_mentions` ON `connect_message_mentions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `users` ON `users`.`id` = `connect_message_mentions`.`user_id` LEFT OUTER JOIN `connect_message_shared_files` `message_shared_files_connect_messages_join` ON `message_shared_files_connect_messages_join`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_shared_files` ON `connect_shared_files`.`id` = `message_shared_files_connect_messages_join`.`connect_shared_file_id` LEFT OUTER JOIN `users` `froms_connect_messages` ON `froms_connect_messages`.`id` = `connect_messages`.`from_id` WHERE `connect_messages`.`to_type` = 'Connect::Room' AND `connect_messages`.`to_id` = 1976 AND (connect_messages.created_at > '2019-06-17 17:26:47') AND (connect_messages.updated_at > '2019-06-18 20:53:31') AND `connect_messages`.`id` IN (41795810, 41795809, 41795808, 41795807, 41795806, 41795805, 41795804, 41795803, 41795802, 41795801, 41795800, 41795799, 41795798, 41795797, 41795796, 41795795, 41795794, 41795793, 41795792, 41795791) ORDER BY connect_messages.created_at desc
	User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1
	UserTitle Load (1.0ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201
	Territory Load (1.2ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1
	Directory::Branch Load (0.8ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3
	Department Load (1.3ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20
	Connect::Room Load (1.2ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1
	Connect::RoomMembership Load (1.2ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE (broadcaster = 1 and user_id is not null) AND `connect_room_memberships`.`connect_room_id` = 1976
	Connect::Bookmark Load (1.2ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' AND `connect_bookmarks`.`bookmarkable_id` = 1976
	CACHE Connect::RoomMembership Load (0.0ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976
	CACHE (0.0ms) select user_id, connect_room_id, connect_bookmark_id, broadcaster from connect_room_users where 1=1 and connect_room_id in (1976) UNION ALL select null, id, null, 0 from connect_rooms where private=0 and archived=0 and id not in (select connect_room_id from connect_room_users)
	CACHE (0.0ms) select user_id, connect_room_id, connect_bookmark_id, broadcaster from connect_room_users where 1=1 and connect_room_id in (1976) UNION ALL select null, id, null, 0 from connect_rooms where private=0 and archived=0 and id not in (select connect_room_id from connect_room_users)
No results found