8 |
0.000877 |
SELECT `s_c_k`.* FROM `summary_count_kuchikomi` AS `s_c_k` WHERE (s_c_k.is_latest = 1) AND (s_c_k.category_id = 13) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id IN ('1136', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '1168', '1173', '1174', '1175', '1176', '1177', '1178', '1179', '1180', '1181', '1182', '1183', '1184', '1185', '1186', '1187', '1188', '1189', '1190', '1191', '1192', '1193', '1194', '1195', '1196', '1197', '1198', '1199', '1203', '1204', '1205', '1207', '1209', '1212', '1213', '1214', '2300', '2302', '2308')) AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = 0) AND (s_c_k.major_city_id = 0) AND (s_c_k.count > 0)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
s_c_k |
range |
multi |
multi |
28 |
|
59 |
Using index condition; Using where |
|
16 |
0.002497 |
SELECT `s`.`id` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.city_id IN ('1136', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '1168', '1173', '1174', '1175', '1176', '1177', '1178', '1179', '1180', '1181', '1182', '1183', '1184', '1185', '1186', '1187', '1188', '1189', '1190', '1191', '1192', '1193', '1194', '1195', '1196', '1197', '1198', '1199', '1203', '1204', '1205', '1207', '1209', '1212', '1213', '1214', '2300', '2302', '2308'))
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
s |
range |
city_id |
city_id |
5 |
|
401 |
Using index condition; Using where |
|
20 |
0.003207 |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013668', '3013669', '3014307', '3015343', '3016091', '3013670', '3013671', '3013672', '3013673', '3013674', '3013675', '3013676', '3013677', '3013917', '3014446', '3014608', '3014778', '3015158', '3013678', '3016382', '3013679', '3013680', '3013681', '3013945', '3014691', '3014928', '3013684', '3014324', '3014773', '3015157', '3014327', '3015517', '3015518', '3015635', '3014376', '3014483', '3014486', '3014503', '3014930', '3016291', '3013685', '3016086', '3013686', '3015357', '3015923', '3013687', '3013918', '3014936', '3016084', '3016402', '3013688', '3016130', '3014097', '3015326', '3013689', '3013690', '3013691', '3013692', '3013693', '3014250', '3014861', '3015171', '3015445', '3015452', '3016267', '3016329', '3016335', '3013694', '3013695', '3013696', '3013697', '3013919', '3014121', '3014628', '3015325', '3015562', '3013698', '3013699', '3013700', '3013986', '3014071', '3014478', '3013701', '3013702', '3013703', '3014060', '3013227', '3013704', '3013705', '3013935', '3014019', '3014225', '3014477', '3014901', '3015298', '3015916', '3016019', '3016157', '3013706', '3013707', '3013970', '3014253', '3015444', '3013708', '3013709', '3013920', '3014021', '3015395', '3015836', '3013189', '3013192', '3013226', '3013238', '3013710', '3013711', '3013712', '3013713', '3014020', '3014133', '3014406', '3014431', '3014479', '3014526', '3014536', '3014591', '3014606', '3014622', '3014639', '3014706', '3014922', '3015338', '3015358', '3016196', '3016292', '3016481', '3016512', '3013714', '3013715', '3013716', '3014120', '3015235', '3015264', '3015575', '3015586', '3016065', '3013717', '3014098', '3015166', '3013718', '3013719', '3013720', '3013721', '3015396', '3015594', '3013722', '3013969', '3014962', '3013723', '3014880', '3014920', '3015272', '3016079', '3013724', '3013936', '3016092', '3016379', '3013725', '3013726', '3013727', '3013728', '3013729', '3013730', '3013921', '3014360', '3014533', '3015628', '3016003', '3013731', '3015610', '3015650', '3013733', '3014115', '3014163', '3014319', '3015768', '3015769', '3014364', '3014491', '3014663', '3016094')) AND (k.id IN ('3', '6', '10', '11', '12', '13', '15', '21', '23', '24', '25', '27', '30', '31', '37', '39', '40', '41', '45', '46', '47', '51', '53', '55', '56', '59', '62', '65', '72', '78', '85', '86', '91', '96', '97', '99', '100', '101', '103', '108', '115', '119', '122', '123', '125', '131', '132', '133', '136', '138', '148', '149', '150', '151', '152', '154', '160', '162', '168', '169', '170', '172', '173', '182', '184', '186', '189', '190', '191', '204', '208', '225', '226', '227', '338', '364', '453', '475', '519', '522', '529', '534', '539', '714', '755', '872', '899', '920', '953', '985', '1108', '1137', '1144', '1145', '1146', '1147', '1148', '1181', '1195', '1198', '1199', '1205', '1206', '1209', '1210', '1232', '1304', '1315', '1326', '1327', '1339', '1340', '1348'))
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
k |
range |
PRIMARY,ix_school_id_kuchikomi |
PRIMARY |
4 |
|
113 |
Using where |
|
21 |
0.003167 |
SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013668', '3013669', '3014307', '3015343', '3016091', '3013670', '3013671', '3013672', '3013673', '3013674', '3013675', '3013676', '3013677', '3013917', '3014446', '3014608', '3014778', '3015158', '3013678', '3016382', '3013679', '3013680', '3013681', '3013945', '3014691', '3014928', '3013684', '3014324', '3014773', '3015157', '3014327', '3015517', '3015518', '3015635', '3014376', '3014483', '3014486', '3014503', '3014930', '3016291', '3013685', '3016086', '3013686', '3015357', '3015923', '3013687', '3013918', '3014936', '3016084', '3016402', '3013688', '3016130', '3014097', '3015326', '3013689', '3013690', '3013691', '3013692', '3013693', '3014250', '3014861', '3015171', '3015445', '3015452', '3016267', '3016329', '3016335', '3013694', '3013695', '3013696', '3013697', '3013919', '3014121', '3014628', '3015325', '3015562', '3013698', '3013699', '3013700', '3013986', '3014071', '3014478', '3013701', '3013702', '3013703', '3014060', '3013227', '3013704', '3013705', '3013935', '3014019', '3014225', '3014477', '3014901', '3015298', '3015916', '3016019', '3016157', '3013706', '3013707', '3013970', '3014253', '3015444', '3013708', '3013709', '3013920', '3014021', '3015395', '3015836', '3013189', '3013192', '3013226', '3013238', '3013710', '3013711', '3013712', '3013713', '3014020', '3014133', '3014406', '3014431', '3014479', '3014526', '3014536', '3014591', '3014606', '3014622', '3014639', '3014706', '3014922', '3015338', '3015358', '3016196', '3016292', '3016481', '3016512', '3013714', '3013715', '3013716', '3014120', '3015235', '3015264', '3015575', '3015586', '3016065', '3013717', '3014098', '3015166', '3013718', '3013719', '3013720', '3013721', '3015396', '3015594', '3013722', '3013969', '3014962', '3013723', '3014880', '3014920', '3015272', '3016079', '3013724', '3013936', '3016092', '3016379', '3013725', '3013726', '3013727', '3013728', '3013729', '3013730', '3013921', '3014360', '3014533', '3015628', '3016003', '3013731', '3015610', '3015650', '3013733', '3014115', '3014163', '3014319', '3015768', '3015769', '3014364', '3014491', '3014663', '3016094')) AND (k.id IN ('3', '6', '10', '11', '12', '13', '15', '21', '23', '24', '25', '27', '30', '31', '37', '39', '40', '41', '45', '46', '47', '51', '53', '55', '56', '59', '62', '65', '72', '78', '85', '86', '91', '96', '97', '99', '100', '101', '103', '108', '115', '119', '122', '123', '125', '131', '132', '133', '136', '138', '148', '149', '150', '151', '152', '154', '160', '162', '168', '169', '170', '172', '173', '182', '184', '186', '189', '190', '191', '204', '208', '225', '226', '227', '338', '364', '453', '475', '519', '522', '529', '534', '539', '714', '755', '872', '899', '920', '953', '985', '1108', '1137', '1144', '1145', '1146', '1147', '1148', '1181', '1195', '1198', '1199', '1205', '1206', '1209', '1210', '1232', '1304', '1315', '1326', '1327', '1339', '1340', '1348')) 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 |
|
113 |
Using where; Using filesort |
|