20 |
0.003597 |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013814', '3013977', '3014791', '3014796', '3015122', '3015926', '3015956', '3016245', '3013815', '3013816', '3013817', '3013818', '3015027', '3015706', '3013820', '3013821', '3013823', '3013824', '3014462', '3014525', '3015309', '3015487', '3015503', '3015603', '3015707', '3015708', '3015963', '3016144', '3016153', '3016167', '3016202', '3016387', '3015377', '3015703', '3013926', '3014475', '3014788', '3014956', '3015345', '3016322', '3014798', '3014746', '3015709', '3015710', '3015762', '3014128', '3014480', '3014664', '3014917', '3014134', '3014597', '3015698', '3013827', '3013828', '3014104', '3014448', '3016128', '3013829', '3013830', '3013831', '3013832', '3013833', '3013834', '3013836', '3013927', '3013928', '3014035', '3014074', '3014275', '3014308', '3014458', '3014632', '3014766', '3014845', '3014856', '3015386', '3015616', '3015783', '3015813', '3015925', '3016255', '3016280', '3016293', '3016367', '3016485', '3016516', '3013837', '3014508', '3016120', '3013838', '3013840', '3013841', '3013842', '3014576', '3014842', '3014963', '3015004', '3015294', '3015516', '3015604', '3014891', '3014892', '3015746', '3016108', '3013843', '3013844', '3013845', '3013846', '3013847', '3014013', '3014179', '3014992', '3015547', '3015758', '3016263', '3016309', '3014610', '3014874', '3015617', '3015621', '3015655', '3015705', '3014512', '3015021', '3015346', '3013849', '3013850', '3013851', '3013852', '3014432', '3014451', '3014767', '3014876', '3015300', '3016275', '3016410', '3013853', '3015609', '3013854', '3013855', '3013856', '3013857', '3013858', '3013859', '3013860', '3013861', '3013862', '3013863', '3013864', '3013865', '3013899', '3013988', '3014014', '3014036', '3014823', '3014894', '3014957', '3015178', '3015417', '3015476', '3015647', '3015889', '3015907', '3016037', '3016039', '3016099', '3016201', '3016388', '3016425', '3015255', '3015843', '3016308', '3013866', '3014505', '3014506', '3014539')) 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.003677 |
SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013814', '3013977', '3014791', '3014796', '3015122', '3015926', '3015956', '3016245', '3013815', '3013816', '3013817', '3013818', '3015027', '3015706', '3013820', '3013821', '3013823', '3013824', '3014462', '3014525', '3015309', '3015487', '3015503', '3015603', '3015707', '3015708', '3015963', '3016144', '3016153', '3016167', '3016202', '3016387', '3015377', '3015703', '3013926', '3014475', '3014788', '3014956', '3015345', '3016322', '3014798', '3014746', '3015709', '3015710', '3015762', '3014128', '3014480', '3014664', '3014917', '3014134', '3014597', '3015698', '3013827', '3013828', '3014104', '3014448', '3016128', '3013829', '3013830', '3013831', '3013832', '3013833', '3013834', '3013836', '3013927', '3013928', '3014035', '3014074', '3014275', '3014308', '3014458', '3014632', '3014766', '3014845', '3014856', '3015386', '3015616', '3015783', '3015813', '3015925', '3016255', '3016280', '3016293', '3016367', '3016485', '3016516', '3013837', '3014508', '3016120', '3013838', '3013840', '3013841', '3013842', '3014576', '3014842', '3014963', '3015004', '3015294', '3015516', '3015604', '3014891', '3014892', '3015746', '3016108', '3013843', '3013844', '3013845', '3013846', '3013847', '3014013', '3014179', '3014992', '3015547', '3015758', '3016263', '3016309', '3014610', '3014874', '3015617', '3015621', '3015655', '3015705', '3014512', '3015021', '3015346', '3013849', '3013850', '3013851', '3013852', '3014432', '3014451', '3014767', '3014876', '3015300', '3016275', '3016410', '3013853', '3015609', '3013854', '3013855', '3013856', '3013857', '3013858', '3013859', '3013860', '3013861', '3013862', '3013863', '3013864', '3013865', '3013899', '3013988', '3014014', '3014036', '3014823', '3014894', '3014957', '3015178', '3015417', '3015476', '3015647', '3015889', '3015907', '3016037', '3016039', '3016099', '3016201', '3016388', '3016425', '3015255', '3015843', '3016308', '3013866', '3014505', '3014506', '3014539')) 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 |
|