SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 182 | 182 | 7 | |
SELECT `Portfolio`.`id`, `Portfolio`.`subject`, `Portfolio`.`cost`, `Portfolio`.`postcode` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (161, 159, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` IN (45, 95, 96, 102, 104, 105, 136, 149, 146, 147, 43, 61, 59, 25, 24, 15, 460, 463, 464, 467, 488, 489, 490, 491, 492, 512, 535, 536, 537, 555, 598, 627, 631, 660, 662, 663, 665, 666, 667, 668, 669, 670, 671, 673, 675, 677, 682, 686, 687, 688, 743, 751, 752, 787, 795, 796, 849, 850, 852, 853, 910, 956, 970, 971, 974, 994, 1013, 1014, 1015, 1016, 1017, 1028, 1029, 1030, 1031, 1041, 1042, 1043, 1044, 1075, 1076, 1077, 1078, 1103, 1105, 1115, 1143, 1157, 1158, 1160, 1163, 1227, 1235, 1240, 1241, 1242, 1244, 1245, 1249, 1251, 1253, 1254, 1255, 1256, 1259, 1260, 1265, 1270, 1271, 1272, 1273, 1279, 1286, 1287, 1288, 355, 502, 629, 718, 785, 788, 916, 939, 116, 87, 82, 72, 67, 64, 1100, 58, 57, 27, 19, 1207, 1291, 1293, 1294, 1306, 1309, 1315, 1316, 1317, 1333, 1335, 1336, 1337, 1342, 1350, 1354, 1355, 1357, 1361, 1366, 1367, 1370, 1372, 1374, 1375, 1407, 1413, 1420, 1421, 1422, 1424, 1427, 1439, 1444, 1445, 1446, 1447, 1448, 1449, 1450, 1451, 1452, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1484, 1485, 1486, 1487, 1488, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1527, 1528, 1541, 1568, 1582, 1590, 1591, 1592, 1593, 1594, 1595, 1596, 1597, 1605, 1606, 1608, 1612, 1616, 1619, 1625, 1635, 1642, 1646, 1683, 1691, 1693, 1694, 1705, 1706, 1704, 1708, 1713, 1723, 1724, 1725, 1728, 1729, 1731, 1732, 1735, 1737, 1739, 1740, 1741, 1742, 1743, 1744, 1745, 1746, 1747, 1748, 1749, 1750, 1757, 1758, 1766, 1767, 1768, 1264, 1263, 1262, 1261, 204, 1775, 1779, 1781, 1794, 1797, 1798, 1799, 1801, 1802, 1804, 1805, 1807, 1817, 1879, 1892, 1894, 1900, 1903, 1905, 322, 1907, 1908, 1912, 1917, 1951, 1957, 1962, 1963, 1965, 1966, 1968, 1969, 1972, 1982, 1992, 1993, 1994, 1995, 2007, 2009, 2016, 2021, 2022, 2024, 2025, 2026, 2028, 2029, 2030, 2033, 2034, 2035, 2037, 2038, 2039, 2040, 2048, 2053, 2058, 2059, 2063, 2071, 2072, 2077, 2091, 2094, 2101, 2102, 2109, 2112, 2115, 2124, 2125, 2126, 2133, 2135, 2139, 2140, 2147, 2148, 2149, 2160, 2177, 2182, 2184, 2188, 2190, 2192, 2199, 2200, 2201, 2207, 2209, 2221, 2227, 2228, 2231, 2239, 2250, 2251, 2230, 2256, 2272, 2277, 2279, 2285, 2286, 2287, 2288, 2289, 2290, 2291, 2295, 2393, 2394, 2395, 2399, 2401, 2402, 2405, 2407, 2427, 2451) ORDER BY `Portfolio`.`created` DESC LIMIT 6 | 6 | 6 | 8 | maybe slow |