Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `ComMediaSetting`.`id`, `ComMediaSetting`.`key`, `ComMediaSetting`.`value`, `ComMediaSetting`.`en`, `ComMediaSetting`.`fr` FROM `quebecelan_LIVE_H`.`com_media_settings` AS `ComMediaSetting` WHERE 1 = 1 | 32 | 32 | 0 | |
SELECT `Raev`.`id`, `Raev`.`discipline_id`, `Raev`.`status`, `Raev`.`firstName`, `Raev`.`lastName`, `Raev`.`image`, `Raev`.`image_large`, `Raev`.`content`, `Raev`.`content_fr`, `Raev`.`video`, `Raev`.`video_fr` FROM `quebecelan_LIVE_H`.`raevs` AS `Raev` WHERE 1 = 1 ORDER BY rand() ASC LIMIT 1 | 1 | 1 | 6 | maybe slow |
SELECT `MembershipFee`.`user_id` FROM `quebecelan_LIVE_H`.`membership_fees` AS `MembershipFee` WHERE `MembershipFee`.`date_paid` < '2018-04-22 00:00:01' AND `MembershipFee`.`renewal_date` > '2018-04-22 23:59:59' | 165 | 165 | 0 | |
SELECT * from user_types_users LIMIT 0,10000 | 5620 | 5620 | 4 | |
SELECT `DisciplinesUser`.`user_id` FROM `quebecelan_LIVE_H`.`disciplines_users` AS `DisciplinesUser` WHERE `DisciplinesUser`.`discipline_id` = 6 | 638 | 638 | 4 | |
SELECT `Member`.`id`, `Member`.`membership_number`, `Member`.`created`, `Member`.`modified`, `Member`.`edited`, `Member`.`visible`, `Member`.`hide`, `Member`.`enabled`, `Member`.`last_login`, `Member`.`user_type_id`, `Member`.`email`, `Member`.`password`, `Member`.`slug`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`organisation_name`, `Member`.`contact_name`, `Member`.`contact_title`, `Member`.`contact_telephone`, `Member`.`contact_email`, `Member`.`about_us`, `Member`.`institution`, `Member`.`label`, `Member`.`sort_label`, `Member`.`street`, `Member`.`city`, `Member`.`region_id`, `Member`.`province_id`, `Member`.`postal_code`, `Member`.`telephone`, `Member`.`fax`, `Member`.`display_email`, `Member`.`website`, `Member`.`bio`, `Member`.`notes`, `Member`.`stature_id`, `Member`.`learned_about_source_id`, `Member`.`headshot_location`, `Member`.`headshot`, `Member`.`headshot_width`, `Member`.`headshot_height`, `Member`.`headshot_mimetype`, `Member`.`mentor`, `Member`.`mentee`, `Member`.`p_a_d`, `Member`.`public`, `Member`.`lng`, `Member`.`lat`, `Member`.`doNotEmail`, `Member`.`optin`, `Member`.`optin_ip`, `Member`.`optin_date`, `Member`.`unsubscribed_date` FROM `quebecelan_LIVE_H`.`users` AS `Member` WHERE ((`Member`.`id` IN (10, 11, 2741, 2790, 22, 24, 29, 3639, 40, 1795, 50, 51, 56, 60, 2640, 66, 68, 70, 74, 81, 85, 88, 89, 93, 94, 100, 104, 105, 107, 109, 116, 123, 125, 127, 128, 130, 133, 134, 140, 148, 149, 150, 152, 154, 159, 163, 165, 166, 167, 176, 177, 180, 186, 188, 1885, 196, 203, 205, 207, 230, 231, 232, 240, 243, 249, 251, 255, 259, 260, 274, 282, 287, 288, 292, 296, 316, 318, 321, 324, 338, 340, 341, 343, 345, 350, 352, 355, 358, 363, 365, 371, 379, 380, 382, 383, 387, 390, 400, 403, 411, 3727, 423, 433, 437, 444, 453, 461, 481, 484, 502, 505, 507, 508, 510, 511, 536, 539, 580, 582, 589, 590, 591, 603, 606, 609, 610, 614, 628, 634, 640, 641, 642, 645, 648, 657, 661, 665, 669, 671, 675, 684, 685, 686, 689, 693, 697, 2554, 2331, 720, 727, 731, 738, 741, 745, 2807, 755, 756, 757, 759, 764, 767, 774, 779, 792, 795, 805, 2234, 834, 835, 838, 839, 843, 846, 866, 878, 888, 900, 901, 905, 907, 913, 914, 918, 3273, 937, 941, 945, 949, 951, 963, 964, 974, 975, 977, 980, 991, 1007, 1013, 1014, 1017, 1018, 1021, 1022, 1023, 1025, 1026, 1030, 1035, 1036, 1049, 1051, 1052, 1059, 1060, 1063, 1064, 1070, 1076, 1081, 1096, 1100, 1101, 1105, 1109, 1111, 1113, 1116, 1118, 1119, 1128, 1143, 1144, 1146, 1147, 1151, 1152, 1157, 1160, 1165, 1168, 1169, 1170, 1172, 1176, 1185, 1186, 1194, 1195, 1196, 1203, 1204, 1207, 1210, 1211, 1218, 1224, 1226, 1228, 2792, 1238, 1243, 1246, 1251, 1272, 1278, 1281, 1287, 1293, 1295, 1302, 1309, 1314, 1315, 1318, 1320, 1322, 1326, 1332, 1340, 1342, 1347, 1351, 1353, 1356, 1362, 1365, 1367, 1368, 1375, 1381, 1391, 1408, 1410, 1411, 1413, 1415, 1420, 1434, 1442, 1443, 1444, 1445, 1452, 1454, 1459, 1463, 1464, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1475, 1476, 1477, 1478, 1481, 1482, 1484, 1490, 1491, 1493, 1495, 1497, 1498, 1500, 1505, 1507, 1509, 1511, 1512, 1513, 1518, 1519, 1521, 1522, 1523, 1526, 1527, 1529, 1530, 1539, 1540, 1541, 1552, 1566, 1575, 1576, 1577, 1579, 1581, 1583, 1588, 2396, 1592, 1593, 1594, 1595, 1596, 1597, 1618, 1623, 1626, 1628, 1637, 1639, 1642, 1645, 1646, 1663, 1668, 1671, 1681, 1683, 1684, 1691, 1693, 1699, 1703, 1704, 1705, 1706, 1707, 1709, 1717, 1718, 1719, 1726, 1728, 1729, 1732, 1746, 1756, 896, 1751, 1762, 1765, 1774, 1775, 1777, 1778, 1798, 1802, 1805, 499, 1806, 1810, 1811, 2714, 1821, 3249, 1828, 1831, 1837, 1841, 551, 1846, 2837, 1853, 1854, 1856, 1858, 1860, 1861, 1862, 1863, 1864, 1867, 335, 1871, 1875, 1877, 1879, 1886, 1891, 1910, 1906, 1908, 1914, 1916, 1932, 1946, 1948, 1973, 1984, 1994, 1995, 2006, 2024, 2030, 2035, 2036, 2038, 2039, 2045, 2046, 2067, 2054, 2057, 2058, 2059, 2069, 2318, 2082, 2086, 2087, 2084, 409, 2107, 13, 2111, 2117, 416, 2123, 653, 2183, 2128, 2129, 2130, 2131, 2132, 2133, 2143, 2153, 2173, 2159, 2161, 2169, 375, 2180, 2186, 2194, 2043, 2203, 2212, 2214, 2218, 2349, 2224, 2229, 2301, 2334, 97, 2362, 2369, 2382, 2399, 2546, 2559, 2572, 3349, 2713, 1959, 2583, 3233, 2614, 2616, 2617, 573, 2653, 3322, 1768, 2679, 2674, 719, 2742, 749, 2711, 16, 495, 2716, 2782, 2775, 2798, 2808, 354, 2868, 2784, 3290, 64, 3323, 2867, 3205, 554, 3214, 3251, 3275, 55, 9, 2094, 3338, 3354, 3395, 3397, 3436, 3442, 3476, 3508, 3513, 3518, 3527, 3554, 3532, 3480, 3544, 3561, 3604, 3614, 3615, 3624, 3766, 3631, 3633, 3634, 3635, 3647, 3648, 3653, 3654, 3655, 3688, 3690, 3698, 2479, 3711, 3756, 3794, 3824, 3887, 4055, 2564, 3957, 3994, 3997, 4003, 4004, 4010, 4080, 3393, 4178, 4259, 857, 4342, 4366, 4371, 4374, 4380, 4384, 4386, 4389, 4408, 4422, 4388, 4428, 4447, 4457, 4462, 4470, 4475, 4480, 4496, 4499, 4502, 4508, 4509, 4531, 4533, 4534, 4539, 4567, 4579, 4599, 4605, 4627, 4653, 4693)) AND (`Member`.`id` IN (474, 3243, 2829, 689, 909, 2085, 718, 781, 786, 3394, 3251, 261, 4606, 4608, 4609, 4611, 763, 4612, 1816, 4582, 4615, 3615, 4581, 1910, 3527, 4271, 3868, 4620, 4286, 4327, 4650, 790, 2564, 168, 4291, 184, 3930, 4088, 1848, 594, 99, 4279, 102, 4677, 3948, 556, 1155, 4352, 3933, 4377, 877, 749, 4688, 802, 839, 331, 3636, 181, 2592, 690, 3947, 3423, 375, 2700, 305, 818, 857, 817, 733, 4372, 1836, 3631, 4383, 2865, 322, 4026, 4692, 1177, 567, 1598, 4283, 3322, 555, 3953, 721, 4693, 2453, 869, 3651, 3531, 2172, 4446, 4378, 674, 330, 883, 3377, 4702, 4701))) LIMIT 10 | 10 | 10 | 2 | maybe slow |
SELECT `Showcase`.`id`, `Showcase`.`created`, `Showcase`.`modified`, `Showcase`.`visible`, `Showcase`.`enabled`, `Showcase`.`user_id`, `Showcase`.`date_work_created`, `Showcase`.`lang`, `Showcase`.`media_type_id`, `Showcase`.`video_embed`, `Showcase`.`title`, `Showcase`.`slug`, `Showcase`.`tags`, `Showcase`.`summary`, `Showcase`.`description`, `Showcase`.`publisher`, `Showcase`.`contributor`, `Showcase`.`website`, `Showcase`.`copyright`, `Showcase`.`checksum`, `Showcase`.`directory`, `Showcase`.`location`, `Showcase`.`basename`, `Showcase`.`embed`, `Showcase`.`thumbnail`, `Showcase`.`width`, `Showcase`.`height`, `Showcase`.`mimetype`, `Showcase`.`filesize`, `Showcase`.`duration`, `Showcase`.`address`, `Showcase`.`city`, `Showcase`.`postal_code`, `Showcase`.`venue_id`, `Showcase`.`lng`, `Showcase`.`lat` FROM `quebecelan_LIVE_H`.`showcases` AS `Showcase` WHERE `Showcase`.`user_id` IN (375, 689, 749, 839, 857, 1910, 2564, 3251, 3322, 3527) | 20 | 20 | 2 | maybe slow |
SELECT `MembershipFee`.`id`, `MembershipFee`.`user_id`, `MembershipFee`.`membership_fee_type_id`, `MembershipFee`.`amount`, `MembershipFee`.`date_paid`, `MembershipFee`.`renewal_date`, `MembershipFee`.`notes`, `MembershipFee`.`date_mailed`, `MembershipFee`.`txn_id` FROM `quebecelan_LIVE_H`.`membership_fees` AS `MembershipFee` WHERE `MembershipFee`.`user_id` IN (375, 689, 749, 839, 857, 1910, 2564, 3251, 3322, 3527) | 53 | 53 | 1 | |
SELECT `Discipline`.`id`, `Discipline`.`name`, `Discipline`.`fr`, `Discipline`.`slug`, `DisciplinesUser`.`id`, `DisciplinesUser`.`discipline_id`, `DisciplinesUser`.`user_id` FROM `quebecelan_LIVE_H`.`disciplines` AS `Discipline` JOIN `quebecelan_LIVE_H`.`disciplines_users` AS `DisciplinesUser` ON (`DisciplinesUser`.`user_id` IN (375, 689, 749, 839, 857, 1910, 2564, 3251, 3322, 3527) AND `DisciplinesUser`.`discipline_id` = `Discipline`.`id`) | 49 | 49 | 1 | |
SELECT `UserType`.`id`, `UserType`.`model`, `UserType`.`controller`, `UserType`.`price`, `UserTypesUser`.`id`, `UserTypesUser`.`user_type_id`, `UserTypesUser`.`user_id` FROM `quebecelan_LIVE_H`.`user_types` AS `UserType` JOIN `quebecelan_LIVE_H`.`user_types_users` AS `UserTypesUser` ON (`UserTypesUser`.`user_id` IN (375, 689, 749, 839, 857, 1910, 2564, 3251, 3322, 3527) AND `UserTypesUser`.`user_type_id` = `UserType`.`id`) | 10 | 10 | 0 | |
SELECT COUNT(*) AS `count` FROM `quebecelan_LIVE_H`.`users` AS `Member` WHERE ((`Member`.`id` IN (10, 11, 2741, 2790, 22, 24, 29, 3639, 40, 1795, 50, 51, 56, 60, 2640, 66, 68, 70, 74, 81, 85, 88, 89, 93, 94, 100, 104, 105, 107, 109, 116, 123, 125, 127, 128, 130, 133, 134, 140, 148, 149, 150, 152, 154, 159, 163, 165, 166, 167, 176, 177, 180, 186, 188, 1885, 196, 203, 205, 207, 230, 231, 232, 240, 243, 249, 251, 255, 259, 260, 274, 282, 287, 288, 292, 296, 316, 318, 321, 324, 338, 340, 341, 343, 345, 350, 352, 355, 358, 363, 365, 371, 379, 380, 382, 383, 387, 390, 400, 403, 411, 3727, 423, 433, 437, 444, 453, 461, 481, 484, 502, 505, 507, 508, 510, 511, 536, 539, 580, 582, 589, 590, 591, 603, 606, 609, 610, 614, 628, 634, 640, 641, 642, 645, 648, 657, 661, 665, 669, 671, 675, 684, 685, 686, 689, 693, 697, 2554, 2331, 720, 727, 731, 738, 741, 745, 2807, 755, 756, 757, 759, 764, 767, 774, 779, 792, 795, 805, 2234, 834, 835, 838, 839, 843, 846, 866, 878, 888, 900, 901, 905, 907, 913, 914, 918, 3273, 937, 941, 945, 949, 951, 963, 964, 974, 975, 977, 980, 991, 1007, 1013, 1014, 1017, 1018, 1021, 1022, 1023, 1025, 1026, 1030, 1035, 1036, 1049, 1051, 1052, 1059, 1060, 1063, 1064, 1070, 1076, 1081, 1096, 1100, 1101, 1105, 1109, 1111, 1113, 1116, 1118, 1119, 1128, 1143, 1144, 1146, 1147, 1151, 1152, 1157, 1160, 1165, 1168, 1169, 1170, 1172, 1176, 1185, 1186, 1194, 1195, 1196, 1203, 1204, 1207, 1210, 1211, 1218, 1224, 1226, 1228, 2792, 1238, 1243, 1246, 1251, 1272, 1278, 1281, 1287, 1293, 1295, 1302, 1309, 1314, 1315, 1318, 1320, 1322, 1326, 1332, 1340, 1342, 1347, 1351, 1353, 1356, 1362, 1365, 1367, 1368, 1375, 1381, 1391, 1408, 1410, 1411, 1413, 1415, 1420, 1434, 1442, 1443, 1444, 1445, 1452, 1454, 1459, 1463, 1464, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1475, 1476, 1477, 1478, 1481, 1482, 1484, 1490, 1491, 1493, 1495, 1497, 1498, 1500, 1505, 1507, 1509, 1511, 1512, 1513, 1518, 1519, 1521, 1522, 1523, 1526, 1527, 1529, 1530, 1539, 1540, 1541, 1552, 1566, 1575, 1576, 1577, 1579, 1581, 1583, 1588, 2396, 1592, 1593, 1594, 1595, 1596, 1597, 1618, 1623, 1626, 1628, 1637, 1639, 1642, 1645, 1646, 1663, 1668, 1671, 1681, 1683, 1684, 1691, 1693, 1699, 1703, 1704, 1705, 1706, 1707, 1709, 1717, 1718, 1719, 1726, 1728, 1729, 1732, 1746, 1756, 896, 1751, 1762, 1765, 1774, 1775, 1777, 1778, 1798, 1802, 1805, 499, 1806, 1810, 1811, 2714, 1821, 3249, 1828, 1831, 1837, 1841, 551, 1846, 2837, 1853, 1854, 1856, 1858, 1860, 1861, 1862, 1863, 1864, 1867, 335, 1871, 1875, 1877, 1879, 1886, 1891, 1910, 1906, 1908, 1914, 1916, 1932, 1946, 1948, 1973, 1984, 1994, 1995, 2006, 2024, 2030, 2035, 2036, 2038, 2039, 2045, 2046, 2067, 2054, 2057, 2058, 2059, 2069, 2318, 2082, 2086, 2087, 2084, 409, 2107, 13, 2111, 2117, 416, 2123, 653, 2183, 2128, 2129, 2130, 2131, 2132, 2133, 2143, 2153, 2173, 2159, 2161, 2169, 375, 2180, 2186, 2194, 2043, 2203, 2212, 2214, 2218, 2349, 2224, 2229, 2301, 2334, 97, 2362, 2369, 2382, 2399, 2546, 2559, 2572, 3349, 2713, 1959, 2583, 3233, 2614, 2616, 2617, 573, 2653, 3322, 1768, 2679, 2674, 719, 2742, 749, 2711, 16, 495, 2716, 2782, 2775, 2798, 2808, 354, 2868, 2784, 3290, 64, 3323, 2867, 3205, 554, 3214, 3251, 3275, 55, 9, 2094, 3338, 3354, 3395, 3397, 3436, 3442, 3476, 3508, 3513, 3518, 3527, 3554, 3532, 3480, 3544, 3561, 3604, 3614, 3615, 3624, 3766, 3631, 3633, 3634, 3635, 3647, 3648, 3653, 3654, 3655, 3688, 3690, 3698, 2479, 3711, 3756, 3794, 3824, 3887, 4055, 2564, 3957, 3994, 3997, 4003, 4004, 4010, 4080, 3393, 4178, 4259, 857, 4342, 4366, 4371, 4374, 4380, 4384, 4386, 4389, 4408, 4422, 4388, 4428, 4447, 4457, 4462, 4470, 4475, 4480, 4496, 4499, 4502, 4508, 4509, 4531, 4533, 4534, 4539, 4567, 4579, 4599, 4605, 4627, 4653, 4693)) AND (`Member`.`id` IN (474, 3243, 2829, 689, 909, 2085, 718, 781, 786, 3394, 3251, 261, 4606, 4608, 4609, 4611, 763, 4612, 1816, 4582, 4615, 3615, 4581, 1910, 3527, 4271, 3868, 4620, 4286, 4327, 4650, 790, 2564, 168, 4291, 184, 3930, 4088, 1848, 594, 99, 4279, 102, 4677, 3948, 556, 1155, 4352, 3933, 4377, 877, 749, 4688, 802, 839, 331, 3636, 181, 2592, 690, 3947, 3423, 375, 2700, 305, 818, 857, 817, 733, 4372, 1836, 3631, 4383, 2865, 322, 4026, 4692, 1177, 567, 1598, 4283, 3322, 555, 3953, 721, 4693, 2453, 869, 3651, 3531, 2172, 4446, 4378, 674, 330, 883, 3377, 4702, 4701))) | 1 | 1 | 1 | |
SELECT `Discipline`.`id`, `Discipline`.`name` FROM `quebecelan_LIVE_H`.`disciplines` AS `Discipline` WHERE 1 = 1 | 11 | 11 | 0 | |