Created
June 18, 2019 21:30
-
-
Save gregblake/cede0f6962f46cca560db6f1af4056d3 to your computer and use it in GitHub Desktop.
Before PR #11607
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- ~264 queries | |
| (4.8ms) select user_id, connect_room_id, connect_bookmark_id, broadcaster from connect_room_users where 1=1 and (user_id = 31995) UNION ALL select null, id, null, 0 from connect_rooms where private=0 and archived=0 and id not in (select bookmarkable_id from connect_bookmarks where bookmarkable_type='Connect::Room' and user_id=31995) | |
| (2.7ms) SELECT `connect_rooms`.`id` FROM `connect_rooms` WHERE `connect_rooms`.`id` IN (64, 121, 138, 157, 164, 193, 202, 308, 326, 590, 1301, 1341, 1511, 1681, 1976, 2216, 2686, 3096, 3316, 3536, 3617, 3622, 3662, 4975, 5005, 5030, 5223, 5498, 5508, 5568, 5903, 6913, 6998, 7138, 7713, 7803, 8458, 8533, 8563, 8598, 8763, 8923, 9023, 9028, 9033, 9513, 9748, 9813, 9948, 9953, 9958, 9963, 9968, 9973, 9978, 9983, 10253, 10278, 10373, 10606, 10611, 10643, 10648, 10652, 10657, 10663, 10668, 10733, 10783, 10892, 10962, 11083, 11208, 11213, 11217, 11232, 11233, 11242, 11358, 11362, 11423, 11427, 11432, 11483, 11487, 11497, 11503, 11507, 11512, 11513, 11602, 11638, 11713, 11813, 12143, 12213, 12233, 12508, 12618, 12733, 13243, 13508, 13723, 13828, 14541, 15106, 15596, 15866, 15931, 16496, 16566, 16591, 16871, 16916, 17171, 17491, 17681, 17709, 17714, 17769, 17774, 18029, 18034, 18954, 19274, 19474, 19874, 20809, 20824, 21159, 21234, 21474, 22069, 22344, 22399, 22614, 23049, 23264, 23269, 23279, 23349, 23354, 23514, 23829, 24004, 24199, 24259, 24655, 24656, 24657, 24658, 1, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 15, 18, 20, 21, 28, 31, 32, 33, 35, 36, 40, 41, 42, 43, 44, 45, 47, 49, 50, 51, 52, 55, 57, 58, 62, 63, 65, 66, 67, 68, 70, 72, 74, 75, 76, 77, 79, 82, 83, 85, 87, 88, 90, 91, 93, 95, 96, 97, 98, 99, 101, 102, 105, 107, 108, 111, 112, 115, 116, 117, 118, 119, 122, 123, 124, 128, 129, 130, 133, 134, 136, 137, 139, 140, 141, 142, 143, 145, 146, 147, 148, 151, 152, 153, 154, 155, 156, 159, 160, 161, 162, 165, 166, 167, 168, 169, 171, 174, 175, 177, 178, 184, 186, 188, 216, 221, 228, 231, 235, 240, 241, 246, 251, 256, 260, 263, 268, 270, 273, 278, 283, 285, 288, 290, 295, 300, 310, 320, 332, 352, 427, 432, 442, 537, 542, 545, 547, 550, 562, 565, 567, 577, 579, 597, 604, 605, 673, 679, 693, 698, 699, 704, 760, 765, 775, 795, 831, 835, 880, 893, 896, 898, 901, 905, 910, 911, 916, 921, 923, 925, 956, 996, 1015, 1021, 1025, 1026, 1091, 1211, 1251, 1276, 1311, 1321, 1636, 1716, 1791, 1811, 1906, 1991, 2011, 2016, 2061, 2081, 2111, 2131, 2176, 2191, 2201, 2211, 2231, 2291, 2446, 2471, 2491, 2526, 2531, 2586, 2646, 2651, 2656, 2881, 2926, 2941, 2961, 2966, 3001, 3016, 3021, 3036, 3056, 3061, 3066, 3131, 3141, 3166, 3186, 3191, 3196, 3201, 3266, 3271, 3276, 3286, 3296, 3326, 3331, 3386, 3391, 3421, 3426, 3486, 3491, 3501, 3506, 3556, 3561, 3672, 3677, 3682, 3692, 3757, 3772, 3827, 3897, 4082, 4087, 4372, 4467, 4551, 4586, 4656, 4721, 4880, 4895, 4985, 5040, 5170, 5248, 5263, 5343, 5348, 5448, 5478, 5488, 5598, 5638, 5643, 5683, 5948, 6273, 6278, 6283, 6288, 6293, 6298, 6383, 6723, 6803, 6848, 6888, 6898, 6908, 7003, 7028, 7033, 7038, 7123, 7208, 7233, 7278, 7283, 7288, 7293, 7298, 7303, 7308, 7313, 7343, 7348, 7353, 7413, 7463, 7473, 7503, 7543, 7668, 7723, 7748, 7753, 7843, 7858, 7943, 8003, 8053, 8083, 8403, 8493, 8528, 8573, 8643, 8648, 8678, 8738, 8788, 8793, 8833, 8938, 8943, 8983, 9058, 9083, 9103, 9118, 9128, 9173, 9348, 9643, 9708, 9843, 9848, 9853, 9858, 9863, 9898, 9903, 9913, 10098, 10158, 10378, 10493, 10708, 10712, 10713, 10723, 10728, 10863, 10943, 10998, 11057, 11183, 11227, 11238, 11307, 11308, 11332, 11348, 11472, 11537, 11572, 11637, 11652, 11658, 11662, 11672, 11697, 11708, 11758, 11787, 11828, 11842, 11867, 11917, 11928, 12013, 12123, 12148, 12538, 12813, 12903, 12913, 12923, 13208, 13248, 13488, 13503, 13593, 13598, 13688, 13843, 13988, 14418, 15811, 15916, 16106, 16276, 16351, 16671, 17021, 17051, 17101, 17141, 17191, 17894, 18119, 18254, 18259, 18279, 18399, 18584, 18649, 18669, 18824, 18884, 18889, 19239, 19264, 19404, 19454, 19654, 20109, 20149, 20519, 20914, 20994, 21069, 21454, 22799, 22824, 22829, 23144, 23234, 23609, 23979, 24169, 24379, 24469, 24555) | |
| SQL (1.5ms) 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 ((to_type='User' and 31995 in (from_id, to_id)) or (to_type='Connect::Room' and to_id in (1,3,4,5,6,8,9,10,11,12,13,15,18,20,21,28,31,32,33,35,36,40,41,42,43,44,45,47,49,50,51,52,55,57,58,62,63,64,65,66,67,68,70,72,74,75,76,77,79,82,83,85,87,88,90,91,93,95,96,97,98,99,101,102,105,107,108,111,112,115,116,117,118,119,121,122,123,124,128,129,130,133,134,136,137,138,139,140,141,142,143,145,146,147,148,151,152,153,154,155,156,157,159,160,161,162,164,165,166,167,168,169,171,174,175,177,178,184,186,188,193,202,216,221,228,231,235,240,241,246,251,256,260,263,268,270,273,278,283,285,288,290,295,300,308,310,320,326,332,352,427,432,442,537,542,545,547,550,562,565,567,577,579,590,597,604,605,673,679,693,698,699,704,760,765,775,795,831,835,880,893,896,898,901,905,910,911,916,921,923,925,956,996,1015,1021,1025,1026,1091,1211,1251,1276,1301,1311,1321,1341,1511,1636,1681,1716,1791,1811,1906,1976,1991,2011,2016,2061,2081,2111,2131,2176,2191,2201,2211,2216,2231,2291,2446,2471,2491,2526,2531,2586,2646,2651,2656,2686,2881,2926,2941,2961,2966,3001,3016,3021,3036,3056,3061,3066,3096,3131,3141,3166,3186,3191,3196,3201,3266,3271,3276,3286,3296,3316,3326,3331,3386,3391,3421,3426,3486,3491,3501,3506,3536,3556,3561,3617,3622,3662,3672,3677,3682,3692,3757,3772,3827,3897,4082,4087,4372,4467,4551,4586,4656,4721,4880,4895,4975,4985,5005,5030,5040,5170,5223,5248,5263,5343,5348,5448,5478,5488,5498,5508,5568,5598,5638,5643,5683,5903,5948,6273,6278,6283,6288,6293,6298,6383,6723,6803,6848,6888,6898,6908,6913,6998,7003,7028,7033,7038,7123,7138,7208,7233,7278,7283,7288,7293,7298,7303,7308,7313,7343,7348,7353,7413,7463,7473,7503,7543,7668,7713,7723,7748,7753,7803,7843,7858,7943,8003,8053,8083,8403,8458,8493,8528,8533,8563,8573,8598,8643,8648,8678,8738,8763,8788,8793,8833,8923,8938,8943,8983,9023,9028,9033,9058,9083,9103,9118,9128,9173,9348,9513,9643,9708,9748,9813,9843,9848,9853,9858,9863,9898,9903,9913,9948,9953,9958,9963,9968,9973,9978,9983,10098,10158,10253,10278,10373,10378,10493,10606,10611,10643,10648,10652,10657,10663,10668,10708,10712,10713,10723,10728,10733,10783,10863,10892,10943,10962,10998,11057,11083,11183,11208,11213,11217,11227,11232,11233,11238,11242,11307,11308,11332,11348,11358,11362,11423,11427,11432,11472,11483,11487,11497,11503,11507,11512,11513,11537,11572,11602,11637,11638,11652,11658,11662,11672,11697,11708,11713,11758,11787,11813,11828,11842,11867,11917,11928,12013,12123,12143,12148,12213,12233,12508,12538,12618,12733,12813,12903,12913,12923,13208,13243,13248,13488,13503,13508,13593,13598,13688,13723,13828,13843,13988,14418,14541,15106,15596,15811,15866,15916,15931,16106,16276,16351,16496,16566,16591,16671,16871,16916,17021,17051,17101,17141,17171,17191,17491,17681,17709,17714,17769,17774,17894,18029,18034,18119,18254,18259,18279,18399,18584,18649,18669,18824,18884,18889,18954,19239,19264,19274,19404,19454,19474,19654,19874,20109,20149,20519,20809,20824,20914,20994,21069,21159,21234,21454,21474,22069,22344,22399,22614,22799,22824,22829,23049,23144,23234,23264,23269,23279,23349,23354,23514,23609,23829,23979,24004,24169,24199,24259,24379,24469,24555,24655,24656,24657,24658))) AND `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.9ms) 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 ((to_type='User' and 31995 in (from_id, to_id)) or (to_type='Connect::Room' and to_id in (1,3,4,5,6,8,9,10,11,12,13,15,18,20,21,28,31,32,33,35,36,40,41,42,43,44,45,47,49,50,51,52,55,57,58,62,63,64,65,66,67,68,70,72,74,75,76,77,79,82,83,85,87,88,90,91,93,95,96,97,98,99,101,102,105,107,108,111,112,115,116,117,118,119,121,122,123,124,128,129,130,133,134,136,137,138,139,140,141,142,143,145,146,147,148,151,152,153,154,155,156,157,159,160,161,162,164,165,166,167,168,169,171,174,175,177,178,184,186,188,193,202,216,221,228,231,235,240,241,246,251,256,260,263,268,270,273,278,283,285,288,290,295,300,308,310,320,326,332,352,427,432,442,537,542,545,547,550,562,565,567,577,579,590,597,604,605,673,679,693,698,699,704,760,765,775,795,831,835,880,893,896,898,901,905,910,911,916,921,923,925,956,996,1015,1021,1025,1026,1091,1211,1251,1276,1301,1311,1321,1341,1511,1636,1681,1716,1791,1811,1906,1976,1991,2011,2016,2061,2081,2111,2131,2176,2191,2201,2211,2216,2231,2291,2446,2471,2491,2526,2531,2586,2646,2651,2656,2686,2881,2926,2941,2961,2966,3001,3016,3021,3036,3056,3061,3066,3096,3131,3141,3166,3186,3191,3196,3201,3266,3271,3276,3286,3296,3316,3326,3331,3386,3391,3421,3426,3486,3491,3501,3506,3536,3556,3561,3617,3622,3662,3672,3677,3682,3692,3757,3772,3827,3897,4082,4087,4372,4467,4551,4586,4656,4721,4880,4895,4975,4985,5005,5030,5040,5170,5223,5248,5263,5343,5348,5448,5478,5488,5498,5508,5568,5598,5638,5643,5683,5903,5948,6273,6278,6283,6288,6293,6298,6383,6723,6803,6848,6888,6898,6908,6913,6998,7003,7028,7033,7038,7123,7138,7208,7233,7278,7283,7288,7293,7298,7303,7308,7313,7343,7348,7353,7413,7463,7473,7503,7543,7668,7713,7723,7748,7753,7803,7843,7858,7943,8003,8053,8083,8403,8458,8493,8528,8533,8563,8573,8598,8643,8648,8678,8738,8763,8788,8793,8833,8923,8938,8943,8983,9023,9028,9033,9058,9083,9103,9118,9128,9173,9348,9513,9643,9708,9748,9813,9843,9848,9853,9858,9863,9898,9903,9913,9948,9953,9958,9963,9968,9973,9978,9983,10098,10158,10253,10278,10373,10378,10493,10606,10611,10643,10648,10652,10657,10663,10668,10708,10712,10713,10723,10728,10733,10783,10863,10892,10943,10962,10998,11057,11083,11183,11208,11213,11217,11227,11232,11233,11238,11242,11307,11308,11332,11348,11358,11362,11423,11427,11432,11472,11483,11487,11497,11503,11507,11512,11513,11537,11572,11602,11637,11638,11652,11658,11662,11672,11697,11708,11713,11758,11787,11813,11828,11842,11867,11917,11928,12013,12123,12143,12148,12213,12233,12508,12538,12618,12733,12813,12903,12913,12923,13208,13243,13248,13488,13503,13508,13593,13598,13688,13723,13828,13843,13988,14418,14541,15106,15596,15811,15866,15916,15931,16106,16276,16351,16496,16566,16591,16671,16871,16916,17021,17051,17101,17141,17171,17191,17491,17681,17709,17714,17769,17774,17894,18029,18034,18119,18254,18259,18279,18399,18584,18649,18669,18824,18884,18889,18954,19239,19264,19274,19404,19454,19474,19654,19874,20109,20149,20519,20809,20824,20914,20994,21069,21159,21234,21454,21474,22069,22344,22399,22614,22799,22824,22829,23049,23144,23234,23264,23269,23279,23349,23354,23514,23609,23829,23979,24004,24169,24199,24259,24379,24469,24555,24655,24656,24657,24658))) AND `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 | |
| Connect::Message Load (1.2ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795804 LIMIT 1 | |
| Connect::MessageReaction Load (1.1ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795804 | |
| Connect::SharedFile Load (1.4ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795804 | |
| Connect::MessageMention Load (1.1ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795804 | |
| User Load (2.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.3ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.4ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.1ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (0.9ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.0ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.5ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (4.5ms) 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) | |
| Connect::Bookmark Load (1.3ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.2ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795805 LIMIT 1 | |
| Connect::MessageReaction Load (1.4ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795805 | |
| Connect::SharedFile Load (1.3ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795805 | |
| Connect::MessageMention Load (1.0ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795805 | |
| User Load (1.0ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.0ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.0ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.0ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.2ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.4ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.4ms) 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) | |
| 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) | |
| Connect::Bookmark Load (1.5ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.2ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795806 LIMIT 1 | |
| Connect::MessageReaction Load (1.0ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795806 | |
| Connect::SharedFile Load (1.2ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795806 | |
| Connect::MessageMention Load (1.1ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795806 | |
| User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.2ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.1ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.4ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.3ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.3ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.4ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (3.9ms) 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) | |
| Connect::Bookmark Load (1.2ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.0ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795807 LIMIT 1 | |
| Connect::MessageReaction Load (1.0ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795807 | |
| Connect::SharedFile Load (1.2ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795807 | |
| Connect::MessageMention Load (1.3ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795807 | |
| User Load (1.8ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.8ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.3ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.2ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.0ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.4ms) 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 `connect_room_memberships`.`connect_room_id` = 1976 | |
| (3.9ms) 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) | |
| Connect::Bookmark Load (1.3ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.2ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795808 LIMIT 1 | |
| Connect::MessageReaction Load (1.5ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795808 | |
| Connect::SharedFile Load (1.4ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795808 | |
| Connect::MessageMention Load (1.3ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795808 | |
| User Load (1.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.2ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.0ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.2ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.0ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| 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.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) | |
| Connect::Bookmark Load (1.4ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.3ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795809 LIMIT 1 | |
| Connect::MessageReaction Load (1.6ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795809 | |
| Connect::SharedFile Load (1.3ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795809 | |
| Connect::MessageMention Load (1.1ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795809 | |
| User Load (1.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.0ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (0.9ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.1ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (0.9ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (0.9ms) 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 `connect_room_memberships`.`connect_room_id` = 1976 | |
| (3.8ms) 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) | |
| Connect::Bookmark Load (1.1ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.0ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795810 LIMIT 1 | |
| Connect::MessageReaction Load (1.0ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795810 | |
| Connect::SharedFile Load (1.4ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795810 | |
| Connect::MessageMention Load (1.3ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795810 | |
| User Load (1.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.1ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.0ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.3ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.5ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.1ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.8ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (4.3ms) 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) | |
| Connect::Bookmark Load (1.3ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.1ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795800 LIMIT 1 | |
| Connect::MessageReaction Load (1.0ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795800 | |
| Connect::SharedFile Load (1.2ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795800 | |
| Connect::MessageMention Load (1.0ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795800 | |
| User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.1ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.3ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.5ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.5ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.4ms) 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 `connect_room_memberships`.`connect_room_id` = 1976 | |
| (4.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) | |
| Connect::Bookmark Load (1.2ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.3ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795801 LIMIT 1 | |
| Connect::MessageReaction Load (1.5ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795801 | |
| Connect::SharedFile Load (1.3ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795801 | |
| Connect::MessageMention Load (1.2ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795801 | |
| User Load (2.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.2ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.1ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.1ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.2ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.4ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.3ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (3.8ms) 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) | |
| Connect::Bookmark Load (1.3ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.7ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795802 LIMIT 1 | |
| Connect::MessageReaction Load (1.5ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795802 | |
| Connect::SharedFile Load (1.3ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795802 | |
| Connect::MessageMention Load (1.3ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795802 | |
| User Load (1.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.1ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.0ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.1ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.1ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.2ms) 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.5ms) 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) | |
| Connect::Bookmark Load (1.5ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.3ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795803 LIMIT 1 | |
| Connect::MessageReaction Load (1.1ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795803 | |
| Connect::SharedFile Load (1.0ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795803 | |
| Connect::MessageMention Load (1.3ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795803 | |
| User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.2ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.1ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.0ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.0ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.0ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.3ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (4.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) | |
| Connect::Bookmark Load (2.2ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.5ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795796 LIMIT 1 | |
| Connect::MessageReaction Load (1.3ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795796 | |
| Connect::SharedFile Load (1.7ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795796 | |
| Connect::MessageMention Load (1.1ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795796 | |
| User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.3ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.1ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.6ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.4ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.1ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.3ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (3.8ms) 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) | |
| Connect::Bookmark Load (1.3ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.1ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795797 LIMIT 1 | |
| Connect::MessageReaction Load (1.1ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795797 | |
| Connect::SharedFile Load (1.3ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795797 | |
| Connect::MessageMention Load (1.8ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795797 | |
| User Load (1.6ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.1ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.3ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.0ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.1ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| 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.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) | |
| Connect::Bookmark Load (1.1ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.3ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795798 LIMIT 1 | |
| Connect::MessageReaction Load (1.2ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795798 | |
| Connect::SharedFile Load (1.2ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795798 | |
| Connect::MessageMention Load (1.0ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795798 | |
| User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.1ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.6ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.4ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (0.9ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.2ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.3ms) 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) | |
| 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) | |
| Connect::Bookmark Load (1.7ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.2ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795799 LIMIT 1 | |
| Connect::MessageReaction Load (1.0ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795799 | |
| Connect::SharedFile Load (1.2ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795799 | |
| Connect::MessageMention Load (1.1ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795799 | |
| User Load (1.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.0ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (0.9ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (0.9ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (0.9ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.3ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.3ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (4.6ms) 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) | |
| Connect::Bookmark Load (1.4ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.1ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795792 LIMIT 1 | |
| Connect::MessageReaction Load (0.9ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795792 | |
| Connect::SharedFile Load (1.0ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795792 | |
| Connect::MessageMention Load (0.9ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795792 | |
| User Load (1.0ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.0ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.0ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.1ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.0ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.0ms) 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 `connect_room_memberships`.`connect_room_id` = 1976 | |
| (3.9ms) 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) | |
| Connect::Bookmark Load (1.3ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.7ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795793 LIMIT 1 | |
| Connect::MessageReaction Load (1.1ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795793 | |
| Connect::SharedFile Load (1.5ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795793 | |
| Connect::MessageMention Load (1.3ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795793 | |
| User Load (1.6ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.4ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.6ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.4ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.6ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.0ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.3ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (4.2ms) 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.1ms) 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) | |
| Connect::Bookmark Load (1.2ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.3ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795794 LIMIT 1 | |
| Connect::MessageReaction Load (1.1ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795794 | |
| Connect::SharedFile Load (1.5ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795794 | |
| Connect::MessageMention Load (1.1ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795794 | |
| User Load (1.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.1ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (0.9ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (0.8ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (0.9ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (0.8ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.0ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (3.5ms) 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) | |
| Connect::Bookmark Load (1.3ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.1ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795795 LIMIT 1 | |
| Connect::MessageReaction Load (1.1ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795795 | |
| Connect::SharedFile Load (1.3ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795795 | |
| Connect::MessageMention Load (1.0ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795795 | |
| User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (1.4ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (1.4ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (1.1ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (2.1ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.1ms) 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 `connect_room_memberships`.`connect_room_id` = 1976 | |
| (4.3ms) 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) | |
| Connect::Bookmark Load (1.6ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' | |
| Connect::Message Load (1.3ms) SELECT `connect_messages`.* FROM `connect_messages` WHERE `connect_messages`.`id` = 41795791 LIMIT 1 | |
| Connect::MessageReaction Load (1.1ms) SELECT `connect_message_reactions`.* FROM `connect_message_reactions` WHERE `connect_message_reactions`.`connect_message_id` = 41795791 | |
| Connect::SharedFile Load (1.2ms) SELECT `connect_shared_files`.* FROM `connect_shared_files` INNER JOIN `connect_message_shared_files` ON `connect_shared_files`.`id` = `connect_message_shared_files`.`connect_shared_file_id` WHERE `connect_message_shared_files`.`connect_message_id` = 41795791 | |
| Connect::MessageMention Load (1.0ms) SELECT `connect_message_mentions`.* FROM `connect_message_mentions` WHERE `connect_message_mentions`.`connect_message_id` = 41795791 | |
| User Load (1.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 618 LIMIT 1 | |
| Territory Load (0.9ms) SELECT `territories`.* FROM `territories` WHERE `territories`.`id` = 1 LIMIT 1 | |
| Directory::Branch Load (0.9ms) SELECT `directory_branches`.* FROM `directory_branches` WHERE `directory_branches`.`id` = 3 LIMIT 1 | |
| Department Load (0.9ms) SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 20 LIMIT 1 | |
| UserTitle Load (1.0ms) SELECT `user_titles`.* FROM `user_titles` WHERE `user_titles`.`id` = 201 LIMIT 1 | |
| Connect::Room Load (1.2ms) SELECT `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1 | |
| Connect::RoomMembership Load (1.5ms) SELECT `connect_room_memberships`.* FROM `connect_room_memberships` WHERE `connect_room_memberships`.`connect_room_id` = 1976 | |
| (4.3ms) 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) | |
| Connect::Bookmark Load (1.8ms) SELECT `connect_bookmarks`.* FROM `connect_bookmarks` WHERE `connect_bookmarks`.`bookmarkable_id` = 1976 AND `connect_bookmarks`.`bookmarkable_type` = 'Connect::Room' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment