20 |
0.007287 |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013172', '3013173', '3013175', '3013176', '3013177', '3013180', '3013183', '3013184', '3013185', '3013186', '3013187', '3013188', '3013190', '3013191', '3013193', '3013194', '3013199', '3013201', '3013208', '3013211', '3013213', '3013214', '3013216', '3013219', '3013220', '3013221', '3013222', '3013224', '3013225', '3013228', '3013230', '3013235', '3013236', '3013237', '3013240', '3013242', '3013243', '3013244', '3013245', '3013246', '3013247', '3013248', '3013252', '3013256', '3013258', '3013260', '3013264', '3013269', '3013271', '3013272', '3013276', '3013279', '3013283', '3013284', '3013285', '3013286', '3013287', '3013292', '3013294', '3013298', '3013306', '3013311', '3013359', '3013360', '3013361', '3013362', '3013363', '3013364', '3013365', '3013366', '3013367', '3013368', '3013369', '3013370', '3013371', '3013372', '3013373', '3013374', '3013375', '3013376', '3013377', '3013378', '3013379', '3013380', '3013381', '3013382', '3013383', '3013384', '3013385', '3013386', '3013387', '3013388', '3013389', '3013390', '3013391', '3013392', '3013393', '3013394', '3013395', '3013396', '3013397', '3013398', '3013399', '3013400', '3013401', '3013402', '3013404', '3013405', '3013406', '3013407', '3013408', '3013409', '3013410', '3013411', '3013412', '3013413', '3013415', '3013416', '3013418', '3013419', '3013420', '3013421', '3013422', '3013423', '3013424', '3013425', '3013426', '3013427', '3013428', '3013429', '3013430', '3013431', '3013432', '3013433', '3013434', '3013435', '3013436', '3013437', '3013438', '3013440', '3013441', '3013442', '3013443', '3013444', '3013445', '3013446', '3013447', '3013448', '3013449', '3013450', '3013451', '3013452', '3013454', '3013455', '3013456', '3013457', '3013459', '3013460', '3013461', '3013463', '3013464', '3013465', '3013466', '3013467', '3013468', '3013469', '3013470', '3013471', '3013472', '3013473', '3013474', '3013475', '3013476', '3013477', '3013478', '3013479', '3013480', '3013482', '3013483', '3013484', '3013485', '3013486', '3013487', '3013488', '3013489', '3013490', '3013491', '3013492', '3013493', '3013494', '3013495', '3013496', '3013497', '3013498', '3013499', '3013500', '3013501', '3013502', '3013503', '3013504', '3013505', '3013506', '3013507', '3013508', '3013509', '3013510', '3013511', '3013512', '3013513', '3013514', '3013515', '3013516', '3013517', '3013518', '3013519', '3013520', '3013521', '3013522', '3013523', '3013524', '3013525', '3013526', '3013527', '3013528', '3013529', '3013530', '3013531', '3013532', '3013533', '3013534', '3013535', '3013896', '3013898', '3013907', '3013932', '3013934', '3013937', '3013941', '3013950', '3013952', '3013953', '3013954', '3013956', '3013961', '3013963', '3013964', '3013966', '3013967', '3013972', '3013974', '3013980', '3013989', '3013990', '3013991', '3013993', '3013994', '3014017', '3014023', '3014024', '3014029', '3014030', '3014031', '3014032', '3014038', '3014039', '3014040', '3014041', '3014047', '3014049', '3014075', '3014078', '3014079', '3014083', '3014087', '3014093', '3014094', '3014095', '3014099', '3014101', '3014107', '3014118', '3014122', '3014125', '3014131', '3014137', '3014138', '3014139', '3014140', '3014142', '3014148', '3014156', '3014161', '3014162', '3014165', '3014171', '3014180', '3014183', '3014187', '3014194', '3014195', '3014196', '3014198', '3014199', '3014202', '3014203', '3014206', '3014208', '3014214', '3014215', '3014219', '3014226', '3014229', '3014234', '3014235', '3014236', '3014237', '3014238', '3014239', '3014240', '3014241', '3014242', '3014243', '3014244', '3014247', '3014252', '3014254', '3014255', '3014256', '3014257', '3014258', '3014260', '3014262', '3014265', '3014268', '3014269', '3014270', '3014272', '3014280', '3014281', '3014288', '3014292', '3014296', '3014298', '3014305', '3014309', '3014311', '3014314', '3014333', '3014334', '3014338', '3014346', '3014348', '3014354', '3014355', '3014361', '3014365', '3014366', '3014370', '3014377', '3014388', '3014396', '3014401', '3014402', '3014407', '3014417', '3014418', '3014421', '3014422', '3014423', '3014425', '3014429', '3014433', '3014435', '3014439', '3014444', '3014447', '3014453', '3014454', '3014459', '3014464', '3014465', '3014466', '3014469', '3014471', '3014488', '3014494', '3014502', '3014511', '3014520', '3014532', '3014537', '3014542', '3014545', '3014549', '3014554', '3014557', '3014559', '3014563', '3014571', '3014572', '3014573', '3014582', '3014583', '3014589', '3014590', '3014601', '3014604', '3014605', '3014609', '3014624', '3014633', '3014637', '3014642', '3014654', '3014657', '3014669', '3014670', '3014674', '3014676', '3014679', '3014681', '3014683', '3014684', '3014692', '3014693', '3014696', '3014697', '3014701', '3014713', '3014714', '3014716', '3014718', '3014719', '3014720', '3014726', '3014731', '3014743', '3014745', '3014748', '3014752', '3014754', '3014755', '3014756', '3014764', '3014768', '3014770', '3014775', '3014781', '3014782', '3014783', '3014784', '3014785', '3014789', '3014790', '3014793', '3014797', '3014800', '3014801', '3014802', '3014803', '3014807', '3014814', '3014819', '3014822', '3014824', '3014830', '3014832', '3014841', '3014848', '3014849', '3014857', '3014858', '3014859', '3014860', '3014864', '3014865', '3014867', '3014875', '3014877', '3014882', '3014883', '3014884', '3014888', '3014890', '3014893', '3014897', '3014899', '3014903', '3014905', '3014906', '3014908', '3014909', '3014912', '3014913', '3014924', '3014927', '3014931', '3014933', '3014935', '3014939', '3014945', '3014953', '3014958', '3014960', '3014961', '3014966', '3014975', '3014977', '3014978', '3014979', '3014980', '3014982', '3014985', '3014989', '3014993', '3015001', '3015007', '3015018', '3015023', '3015024', '3015028', '3015029', '3015030', '3015032', '3015033', '3015035', '3015037', '3015042', '3015049', '3015052', '3015053', '3015054', '3015055', '3015066', '3015072', '3015091', '3015092', '3015094', '3015095', '3015096', '3015103', '3015104', '3015105', '3015106', '3015107', '3015108', '3015110', '3015111', '3015112', '3015113', '3015119', '3015120', '3015140', '3015141', '3015142', '3015145', '3015149', '3015161', '3015162', '3015163', '3015180', '3015182', '3015187', '3015195', '3015209', '3015210', '3015211', '3015212', '3015213', '3015214', '3015215', '3015217', '3015220', '3015221', '3015222', '3015224', '3015225', '3015226', '3015244', '3015246', '3015251', '3015265', '3015266', '3015269', '3015276', '3015280', '3015285', '3015286', '3015293', '3015295', '3015296', '3015297', '3015303', '3015304', '3015308', '3015311', '3015312', '3015316', '3015317', '3015323', '3015327', '3015328', '3015330', '3015339', '3015340', '3015341', '3015344', '3015347', '3015350', '3015352', '3015367', '3015373', '3015375', '3015376', '3015378', '3015379', '3015382', '3015383', '3015384', '3015385', '3015389', '3015398', '3015402', '3015403', '3015405', '3015413', '3015426', '3015427', '3015430', '3015436', '3015439', '3015442', '3015443', '3015447', '3015453', '3015461', '3015462', '3015468', '3015471', '3015472', '3015477', '3015478', '3015480', '3015488', '3015497', '3015499', '3015507', '3015510', '3015514', '3015519', '3015520', '3015521', '3015523', '3015525', '3015526', '3015533', '3015537', '3015541', '3015546', '3015548', '3015549', '3015550', '3015556', '3015558', '3015561', '3015564', '3015569', '3015571', '3015581', '3015589', '3015590', '3015591', '3015596', '3015597', '3015598', '3015601', '3015606', '3015614', '3015618', '3015619', '3015620', '3015622', '3015623', '3015629', '3015630', '3015633', '3015641', '3015658', '3015659', '3015673', '3015674', '3015685', '3015689', '3015693', '3015694', '3015699', '3015711', '3015712', '3015713', '3015714', '3015716', '3015718', '3015724', '3015732', '3015733', '3015735', '3015737', '3015738', '3015739', '3015740', '3015742', '3015749', '3015754', '3015756', '3015760', '3015761', '3015766', '3015770', '3015771', '3015772', '3015774', '3015776', '3015780', '3015784', '3015786', '3015794', '3015795', '3015801', '3015803', '3015804', '3015811', '3015814', '3015816', '3015819', '3015823', '3015829', '3015831', '3015832', '3015833', '3015834', '3015839', '3015840', '3015844', '3015851', '3015854', '3015855', '3015858', '3015860', '3015861', '3015871', '3015884', '3015893', '3015894', '3015896', '3015903', '3015906', '3015911', '3015918', '3015920', '3015928', '3015932', '3015933', '3015934', '3015935', '3015937', '3015944', '3015948', '3015958', '3015959', '3015960', '3015965', '3015970', '3015971', '3015972', '3015974', '3015975', '3015977', '3015981', '3015982', '3015991', '3015992', '3015998', '3016001', '3016005', '3016012', '3016013', '3016018', '3016024', '3016025', '3016027', '3016028', '3016030', '3016031', '3016032', '3016035', '3016042', '3016050', '3016051', '3016053', '3016054', '3016055', '3016061', '3016062', '3016068', '3016070', '3016082', '3016085', '3016088', '3016096', '3016118', '3016124', '3016126', '3016145', '3016148', '3016159', '3016163', '3016164', '3016166', '3016179', '3016182', '3016183', '3016184', '3016190', '3016207', '3016209', '3016210', '3016217', '3016227', '3016230', '3016232', '3016233', '3016234', '3016241', '3016244', '3016249', '3016253', '3016258', '3016268', '3016269', '3016271', '3016277', '3016285', '3016287', '3016290', '3016312', '3016313', '3016320', '3016324', '3016339', '3016340', '3016341', '3016342', '3016343', '3016344', '3016350', '3016354', '3016356', '3016358', '3016369', '3016370', '3016376', '3016386', '3016389', '3016392', '3016399', '3016400', '3016403', '3016404', '3016407', '3016408', '3016409', '3016411', '3016413', '3016418', '3016421', '3016422', '3016424', '3016434', '3016440', '3016442', '3016444', '3016449', '3016454', '3016455', '3016456', '3016457', '3016458', '3016459', '3016460', '3016461', '3016462', '3016463', '3016464', '3016465', '3016466', '3016467', '3016468', '3016469', '3016470', '3016471', '3016472', '3016473', '3016474', '3016475', '3016486', '3016487', '3016488', '3016489', '3016490', '3016491', '3016492', '3016493', '3016494', '3016495', '3016496', '3016497', '3016498', '3016499', '3016500', '3016501', '3016502', '3016503', '3016504', '3016505', '3016506', '3016518')) AND (k.id IN ('2', '6', '10', '17', '20', '35', '47', '51', '57', '58', '82', '111', '116', '124', '137', '167', '187', '188', '335', '463', '465', '484', '531', '554', '605', '735', '963', '982', '983', '1132', '1133', '1204', '1308'))
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
k |
range |
PRIMARY,ix_school_id_kuchikomi |
PRIMARY |
4 |
|
33 |
Using where |
|
21 |
0.007257 |
SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013172', '3013173', '3013175', '3013176', '3013177', '3013180', '3013183', '3013184', '3013185', '3013186', '3013187', '3013188', '3013190', '3013191', '3013193', '3013194', '3013199', '3013201', '3013208', '3013211', '3013213', '3013214', '3013216', '3013219', '3013220', '3013221', '3013222', '3013224', '3013225', '3013228', '3013230', '3013235', '3013236', '3013237', '3013240', '3013242', '3013243', '3013244', '3013245', '3013246', '3013247', '3013248', '3013252', '3013256', '3013258', '3013260', '3013264', '3013269', '3013271', '3013272', '3013276', '3013279', '3013283', '3013284', '3013285', '3013286', '3013287', '3013292', '3013294', '3013298', '3013306', '3013311', '3013359', '3013360', '3013361', '3013362', '3013363', '3013364', '3013365', '3013366', '3013367', '3013368', '3013369', '3013370', '3013371', '3013372', '3013373', '3013374', '3013375', '3013376', '3013377', '3013378', '3013379', '3013380', '3013381', '3013382', '3013383', '3013384', '3013385', '3013386', '3013387', '3013388', '3013389', '3013390', '3013391', '3013392', '3013393', '3013394', '3013395', '3013396', '3013397', '3013398', '3013399', '3013400', '3013401', '3013402', '3013404', '3013405', '3013406', '3013407', '3013408', '3013409', '3013410', '3013411', '3013412', '3013413', '3013415', '3013416', '3013418', '3013419', '3013420', '3013421', '3013422', '3013423', '3013424', '3013425', '3013426', '3013427', '3013428', '3013429', '3013430', '3013431', '3013432', '3013433', '3013434', '3013435', '3013436', '3013437', '3013438', '3013440', '3013441', '3013442', '3013443', '3013444', '3013445', '3013446', '3013447', '3013448', '3013449', '3013450', '3013451', '3013452', '3013454', '3013455', '3013456', '3013457', '3013459', '3013460', '3013461', '3013463', '3013464', '3013465', '3013466', '3013467', '3013468', '3013469', '3013470', '3013471', '3013472', '3013473', '3013474', '3013475', '3013476', '3013477', '3013478', '3013479', '3013480', '3013482', '3013483', '3013484', '3013485', '3013486', '3013487', '3013488', '3013489', '3013490', '3013491', '3013492', '3013493', '3013494', '3013495', '3013496', '3013497', '3013498', '3013499', '3013500', '3013501', '3013502', '3013503', '3013504', '3013505', '3013506', '3013507', '3013508', '3013509', '3013510', '3013511', '3013512', '3013513', '3013514', '3013515', '3013516', '3013517', '3013518', '3013519', '3013520', '3013521', '3013522', '3013523', '3013524', '3013525', '3013526', '3013527', '3013528', '3013529', '3013530', '3013531', '3013532', '3013533', '3013534', '3013535', '3013896', '3013898', '3013907', '3013932', '3013934', '3013937', '3013941', '3013950', '3013952', '3013953', '3013954', '3013956', '3013961', '3013963', '3013964', '3013966', '3013967', '3013972', '3013974', '3013980', '3013989', '3013990', '3013991', '3013993', '3013994', '3014017', '3014023', '3014024', '3014029', '3014030', '3014031', '3014032', '3014038', '3014039', '3014040', '3014041', '3014047', '3014049', '3014075', '3014078', '3014079', '3014083', '3014087', '3014093', '3014094', '3014095', '3014099', '3014101', '3014107', '3014118', '3014122', '3014125', '3014131', '3014137', '3014138', '3014139', '3014140', '3014142', '3014148', '3014156', '3014161', '3014162', '3014165', '3014171', '3014180', '3014183', '3014187', '3014194', '3014195', '3014196', '3014198', '3014199', '3014202', '3014203', '3014206', '3014208', '3014214', '3014215', '3014219', '3014226', '3014229', '3014234', '3014235', '3014236', '3014237', '3014238', '3014239', '3014240', '3014241', '3014242', '3014243', '3014244', '3014247', '3014252', '3014254', '3014255', '3014256', '3014257', '3014258', '3014260', '3014262', '3014265', '3014268', '3014269', '3014270', '3014272', '3014280', '3014281', '3014288', '3014292', '3014296', '3014298', '3014305', '3014309', '3014311', '3014314', '3014333', '3014334', '3014338', '3014346', '3014348', '3014354', '3014355', '3014361', '3014365', '3014366', '3014370', '3014377', '3014388', '3014396', '3014401', '3014402', '3014407', '3014417', '3014418', '3014421', '3014422', '3014423', '3014425', '3014429', '3014433', '3014435', '3014439', '3014444', '3014447', '3014453', '3014454', '3014459', '3014464', '3014465', '3014466', '3014469', '3014471', '3014488', '3014494', '3014502', '3014511', '3014520', '3014532', '3014537', '3014542', '3014545', '3014549', '3014554', '3014557', '3014559', '3014563', '3014571', '3014572', '3014573', '3014582', '3014583', '3014589', '3014590', '3014601', '3014604', '3014605', '3014609', '3014624', '3014633', '3014637', '3014642', '3014654', '3014657', '3014669', '3014670', '3014674', '3014676', '3014679', '3014681', '3014683', '3014684', '3014692', '3014693', '3014696', '3014697', '3014701', '3014713', '3014714', '3014716', '3014718', '3014719', '3014720', '3014726', '3014731', '3014743', '3014745', '3014748', '3014752', '3014754', '3014755', '3014756', '3014764', '3014768', '3014770', '3014775', '3014781', '3014782', '3014783', '3014784', '3014785', '3014789', '3014790', '3014793', '3014797', '3014800', '3014801', '3014802', '3014803', '3014807', '3014814', '3014819', '3014822', '3014824', '3014830', '3014832', '3014841', '3014848', '3014849', '3014857', '3014858', '3014859', '3014860', '3014864', '3014865', '3014867', '3014875', '3014877', '3014882', '3014883', '3014884', '3014888', '3014890', '3014893', '3014897', '3014899', '3014903', '3014905', '3014906', '3014908', '3014909', '3014912', '3014913', '3014924', '3014927', '3014931', '3014933', '3014935', '3014939', '3014945', '3014953', '3014958', '3014960', '3014961', '3014966', '3014975', '3014977', '3014978', '3014979', '3014980', '3014982', '3014985', '3014989', '3014993', '3015001', '3015007', '3015018', '3015023', '3015024', '3015028', '3015029', '3015030', '3015032', '3015033', '3015035', '3015037', '3015042', '3015049', '3015052', '3015053', '3015054', '3015055', '3015066', '3015072', '3015091', '3015092', '3015094', '3015095', '3015096', '3015103', '3015104', '3015105', '3015106', '3015107', '3015108', '3015110', '3015111', '3015112', '3015113', '3015119', '3015120', '3015140', '3015141', '3015142', '3015145', '3015149', '3015161', '3015162', '3015163', '3015180', '3015182', '3015187', '3015195', '3015209', '3015210', '3015211', '3015212', '3015213', '3015214', '3015215', '3015217', '3015220', '3015221', '3015222', '3015224', '3015225', '3015226', '3015244', '3015246', '3015251', '3015265', '3015266', '3015269', '3015276', '3015280', '3015285', '3015286', '3015293', '3015295', '3015296', '3015297', '3015303', '3015304', '3015308', '3015311', '3015312', '3015316', '3015317', '3015323', '3015327', '3015328', '3015330', '3015339', '3015340', '3015341', '3015344', '3015347', '3015350', '3015352', '3015367', '3015373', '3015375', '3015376', '3015378', '3015379', '3015382', '3015383', '3015384', '3015385', '3015389', '3015398', '3015402', '3015403', '3015405', '3015413', '3015426', '3015427', '3015430', '3015436', '3015439', '3015442', '3015443', '3015447', '3015453', '3015461', '3015462', '3015468', '3015471', '3015472', '3015477', '3015478', '3015480', '3015488', '3015497', '3015499', '3015507', '3015510', '3015514', '3015519', '3015520', '3015521', '3015523', '3015525', '3015526', '3015533', '3015537', '3015541', '3015546', '3015548', '3015549', '3015550', '3015556', '3015558', '3015561', '3015564', '3015569', '3015571', '3015581', '3015589', '3015590', '3015591', '3015596', '3015597', '3015598', '3015601', '3015606', '3015614', '3015618', '3015619', '3015620', '3015622', '3015623', '3015629', '3015630', '3015633', '3015641', '3015658', '3015659', '3015673', '3015674', '3015685', '3015689', '3015693', '3015694', '3015699', '3015711', '3015712', '3015713', '3015714', '3015716', '3015718', '3015724', '3015732', '3015733', '3015735', '3015737', '3015738', '3015739', '3015740', '3015742', '3015749', '3015754', '3015756', '3015760', '3015761', '3015766', '3015770', '3015771', '3015772', '3015774', '3015776', '3015780', '3015784', '3015786', '3015794', '3015795', '3015801', '3015803', '3015804', '3015811', '3015814', '3015816', '3015819', '3015823', '3015829', '3015831', '3015832', '3015833', '3015834', '3015839', '3015840', '3015844', '3015851', '3015854', '3015855', '3015858', '3015860', '3015861', '3015871', '3015884', '3015893', '3015894', '3015896', '3015903', '3015906', '3015911', '3015918', '3015920', '3015928', '3015932', '3015933', '3015934', '3015935', '3015937', '3015944', '3015948', '3015958', '3015959', '3015960', '3015965', '3015970', '3015971', '3015972', '3015974', '3015975', '3015977', '3015981', '3015982', '3015991', '3015992', '3015998', '3016001', '3016005', '3016012', '3016013', '3016018', '3016024', '3016025', '3016027', '3016028', '3016030', '3016031', '3016032', '3016035', '3016042', '3016050', '3016051', '3016053', '3016054', '3016055', '3016061', '3016062', '3016068', '3016070', '3016082', '3016085', '3016088', '3016096', '3016118', '3016124', '3016126', '3016145', '3016148', '3016159', '3016163', '3016164', '3016166', '3016179', '3016182', '3016183', '3016184', '3016190', '3016207', '3016209', '3016210', '3016217', '3016227', '3016230', '3016232', '3016233', '3016234', '3016241', '3016244', '3016249', '3016253', '3016258', '3016268', '3016269', '3016271', '3016277', '3016285', '3016287', '3016290', '3016312', '3016313', '3016320', '3016324', '3016339', '3016340', '3016341', '3016342', '3016343', '3016344', '3016350', '3016354', '3016356', '3016358', '3016369', '3016370', '3016376', '3016386', '3016389', '3016392', '3016399', '3016400', '3016403', '3016404', '3016407', '3016408', '3016409', '3016411', '3016413', '3016418', '3016421', '3016422', '3016424', '3016434', '3016440', '3016442', '3016444', '3016449', '3016454', '3016455', '3016456', '3016457', '3016458', '3016459', '3016460', '3016461', '3016462', '3016463', '3016464', '3016465', '3016466', '3016467', '3016468', '3016469', '3016470', '3016471', '3016472', '3016473', '3016474', '3016475', '3016486', '3016487', '3016488', '3016489', '3016490', '3016491', '3016492', '3016493', '3016494', '3016495', '3016496', '3016497', '3016498', '3016499', '3016500', '3016501', '3016502', '3016503', '3016504', '3016505', '3016506', '3016518')) AND (k.id IN ('2', '6', '10', '17', '20', '35', '47', '51', '57', '58', '82', '111', '116', '124', '137', '167', '187', '188', '335', '463', '465', '484', '531', '554', '605', '735', '963', '982', '983', '1132', '1133', '1204', '1308')) ORDER BY `k`.`posted_at` DESC LIMIT 10
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
k |
range |
PRIMARY,ix_school_id_kuchikomi |
PRIMARY |
4 |
|
33 |
Using where; Using filesort |
|