20 |
0.004837 |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013309', '3014689', '3014870', '3015568', '3016067', '3014805', '3013315', '3014872', '3013316', '3013317', '3015639', '3014350', '3013318', '3013290', '3013319', '3013320', '3013321', '3013322', '3013984', '3014112', '3014213', '3014403', '3014497', '3014618', '3014631', '3015540', '3015717', '3015751', '3016169', '3013324', '3013325', '3013326', '3013327', '3015253', '3015409', '3015870', '3016006', '3016416', '3013328', '3013905', '3015588', '3013329', '3016188', '3016353', '3016147', '3016359', '3016420', '3013330', '3013331', '3013332', '3013333', '3013334', '3014762', '3015232', '3015797', '3016326', '3016412', '3013335', '3013336', '3013337', '3013338', '3013339', '3013340', '3014739', '3015380', '3016146', '3016149', '3016272', '3013341', '3013342', '3014050', '3014568', '3014715', '3014896', '3015404', '3015434', '3016374', '3016479', '3016510', '3013343', '3013344', '3013345', '3016014', '3014233', '3014332', '3014659', '3015800', '3014061', '3015542', '3015688', '3013346', '3013347', '3015528', '3016375', '3015143', '3013348', '3014534', '3015781', '3014114', '3014304', '3016212', '3013350', '3013351', '3013352', '3015335', '3016008', '3016213', '3015082', '3015600', '3016114', '3014744', '3014984', '3013353', '3013354', '3013355', '3013356', '3013902', '3014150', '3014232', '3014926', '3015493', '3014065', '3016191', '3016433', '3013357', '3016366', '3014218', '3014408', '3014611', '3013906', '3015320', '3015483', '3015484', '3014869', '3015527', '3016437')) AND (k.id IN ('2', '10', '24', '31', '35', '36', '37', '39', '40', '41', '47', '51', '53', '54', '55', '57', '59', '62', '65', '70', '81', '85', '86', '96', '97', '100', '101', '108', '112', '113', '115', '116', '117', '118', '123', '131', '132', '133', '138', '139', '148', '149', '150', '151', '152', '153', '154', '162', '168', '169', '179', '181', '182', '186', '189', '190', '191', '195', '196', '200', '204', '207', '208', '222', '223', '225', '226', '227', '228', '319', '338', '360', '364', '419', '453', '462', '466', '467', '468', '475', '483', '497', '535', '539', '547', '604', '716', '726', '730', '772', '882', '916', '921', '924', '937', '949', '952', '1068', '1073', '1088', '1092', '1093', '1094', '1100', '1103', '1104', '1106', '1107', '1108', '1110', '1111', '1112', '1114', '1130', '1134', '1137', '1138', '1144', '1145', '1146', '1147', '1148', '1150', '1151', '1156', '1159', '1162', '1163', '1164', '1169', '1173', '1180', '1191', '1194', '1195', '1200', '1206', '1232', '1233', '1234', '1235', '1236', '1237', '1238', '1239', '1240', '1241', '1242', '1257', '1258', '1259', '1260', '1261', '1262', '1263', '1264', '1265', '1266', '1267', '1268', '1269', '1271', '1272', '1273', '1274', '1275', '1276', '1277', '1278', '1279', '1280', '1281', '1282', '1283', '1284', '1285', '1286', '1287', '1288', '1289', '1290', '1291', '1292', '1293', '1294', '1296', '1300', '1301', '1304', '1316', '1317', '1318', '1319', '1320', '1321', '1322', '1330', '1331', '1333', '1338', '1344', '1347', '1349', '1362', '1367', '1371'))
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
k |
ALL |
PRIMARY,ix_school_id_kuchikomi |
|
|
|
809 |
Using where |
|
21 |
0.004927 |
SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013309', '3014689', '3014870', '3015568', '3016067', '3014805', '3013315', '3014872', '3013316', '3013317', '3015639', '3014350', '3013318', '3013290', '3013319', '3013320', '3013321', '3013322', '3013984', '3014112', '3014213', '3014403', '3014497', '3014618', '3014631', '3015540', '3015717', '3015751', '3016169', '3013324', '3013325', '3013326', '3013327', '3015253', '3015409', '3015870', '3016006', '3016416', '3013328', '3013905', '3015588', '3013329', '3016188', '3016353', '3016147', '3016359', '3016420', '3013330', '3013331', '3013332', '3013333', '3013334', '3014762', '3015232', '3015797', '3016326', '3016412', '3013335', '3013336', '3013337', '3013338', '3013339', '3013340', '3014739', '3015380', '3016146', '3016149', '3016272', '3013341', '3013342', '3014050', '3014568', '3014715', '3014896', '3015404', '3015434', '3016374', '3016479', '3016510', '3013343', '3013344', '3013345', '3016014', '3014233', '3014332', '3014659', '3015800', '3014061', '3015542', '3015688', '3013346', '3013347', '3015528', '3016375', '3015143', '3013348', '3014534', '3015781', '3014114', '3014304', '3016212', '3013350', '3013351', '3013352', '3015335', '3016008', '3016213', '3015082', '3015600', '3016114', '3014744', '3014984', '3013353', '3013354', '3013355', '3013356', '3013902', '3014150', '3014232', '3014926', '3015493', '3014065', '3016191', '3016433', '3013357', '3016366', '3014218', '3014408', '3014611', '3013906', '3015320', '3015483', '3015484', '3014869', '3015527', '3016437')) AND (k.id IN ('2', '10', '24', '31', '35', '36', '37', '39', '40', '41', '47', '51', '53', '54', '55', '57', '59', '62', '65', '70', '81', '85', '86', '96', '97', '100', '101', '108', '112', '113', '115', '116', '117', '118', '123', '131', '132', '133', '138', '139', '148', '149', '150', '151', '152', '153', '154', '162', '168', '169', '179', '181', '182', '186', '189', '190', '191', '195', '196', '200', '204', '207', '208', '222', '223', '225', '226', '227', '228', '319', '338', '360', '364', '419', '453', '462', '466', '467', '468', '475', '483', '497', '535', '539', '547', '604', '716', '726', '730', '772', '882', '916', '921', '924', '937', '949', '952', '1068', '1073', '1088', '1092', '1093', '1094', '1100', '1103', '1104', '1106', '1107', '1108', '1110', '1111', '1112', '1114', '1130', '1134', '1137', '1138', '1144', '1145', '1146', '1147', '1148', '1150', '1151', '1156', '1159', '1162', '1163', '1164', '1169', '1173', '1180', '1191', '1194', '1195', '1200', '1206', '1232', '1233', '1234', '1235', '1236', '1237', '1238', '1239', '1240', '1241', '1242', '1257', '1258', '1259', '1260', '1261', '1262', '1263', '1264', '1265', '1266', '1267', '1268', '1269', '1271', '1272', '1273', '1274', '1275', '1276', '1277', '1278', '1279', '1280', '1281', '1282', '1283', '1284', '1285', '1286', '1287', '1288', '1289', '1290', '1291', '1292', '1293', '1294', '1296', '1300', '1301', '1304', '1316', '1317', '1318', '1319', '1320', '1321', '1322', '1330', '1331', '1333', '1338', '1344', '1347', '1349', '1362', '1367', '1371')) ORDER BY `k`.`posted_at` DESC LIMIT 10
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
k |
ALL |
PRIMARY,ix_school_id_kuchikomi |
|
|
|
809 |
Using where; Using filesort |
|