21 |
0.001317 |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013236', '3013518', '3013519', '3013520', '3013521', '3014229', '3014803', '3014877', '3014909', '3014933', '3015226', '3015266', '3015285', '3015548', '3015601', '3016370', '3016465', '3016496')) 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 |
|
22 |
0.001337 |
SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013236', '3013518', '3013519', '3013520', '3013521', '3014229', '3014803', '3014877', '3014909', '3014933', '3015226', '3015266', '3015285', '3015548', '3015601', '3016370', '3016465', '3016496')) 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 |
|