18 |
0.002887 |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013187', '3013225', '3013228', '3013229', '3013236', '3013239', '3013259', '3013264', '3013293', '3013292', '3013297', '3013323', '3013502', '3013899', '3013945', '3013948', '3013956', '3013959', '3013960', '3013973', '3013984', '3013986', '3014001', '3014012', '3014013', '3014015', '3014022', '3014031', '3014034', '3014037', '3014052', '3014055', '3014074', '3014078', '3014092', '3014099', '3014112', '3014124', '3014130', '3014136', '3014146', '3014141', '3014162', '3014167', '3014170', '3014176', '3014187', '3014188', '3014246', '3014261', '3014262', '3014279', '3014313', '3014341', '3014377', '3014415', '3014437', '3014444', '3014451', '3014459', '3014467', '3014469', '3014492', '3014464', '3014532', '3014534', '3014536', '3014552', '3014557', '3014558', '3014577', '3014605', '3014618', '3014627', '3014633', '3014634', '3014647', '3014673', '3014674', '3014200', '3014677', '3014686', '3014725', '3014832', '3014845', '3014849', '3014861', '3014865', '3014907', '3014909', '3014960', '3014972', '3014982', '3014983', '3014991', '3015027', '3015029', '3014442', '3015042', '3014976', '3015053', '3015056', '3015080', '3015083', '3015086', '3015087', '3015100', '3015101', '3015122', '3013312', '3015146', '3015152', '3015308', '3015313', '3015314', '3015315', '3015333', '3015356', '3015375', '3015376', '3015378', '3015380', '3015385', '3015389', '3015395', '3015417', '3015429', '3015430', '3015458', '3015476', '3015531', '3015545', '3015549', '3015579', '3015596', '3015599', '3015602', '3015603', '3015604', '3015629', '3015681', '3015712', '3015764', '3015765', '3015787', '3015798', '3015800', '3015822', '3015831', '3015836', '3015843', '3015880', '3015893', '3015926', '3015925', '3015930', '3015931', '3015937', '3015950', '3016020', '3016035', '3016043', '3013940', '3016080', '3016115', '3016147', '3016151', '3016177', '3016178', '3016120', '3016055', '3016273', '3016311', '3016317', '3016318', '3016324', '3016327', '3016329', '3016343', '3016356', '3016357', '3016370', '3014446', '3016380', '3016381', '3016383', '3016384', '3016363', '3016392', '3016407', '3016408', '3016409', '3016452', '3016453', '3016450')) AND (s.city_id = '1398')
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
s |
range |
PRIMARY,city_id |
city_id |
9 |
|
195 |
Using index condition; Using where |
|
19 |
0.002497 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013187', '3013225', '3013228', '3013229', '3013236', '3013239', '3013259', '3013264', '3013293', '3013292', '3013297', '3013323', '3013502', '3013899', '3013945', '3013948', '3013956', '3013959', '3013960', '3013973', '3013984', '3013986', '3014001', '3014012', '3014013', '3014015', '3014022', '3014031', '3014034', '3014037', '3014052', '3014055', '3014074', '3014078', '3014092', '3014099', '3014112', '3014124', '3014130', '3014136', '3014146', '3014141', '3014162', '3014167', '3014170', '3014176', '3014187', '3014188', '3014246', '3014261', '3014262', '3014279', '3014313', '3014341', '3014377', '3014415', '3014437', '3014444', '3014451', '3014459', '3014467', '3014469', '3014492', '3014464', '3014532', '3014534', '3014536', '3014552', '3014557', '3014558', '3014577', '3014605', '3014618', '3014627', '3014633', '3014634', '3014647', '3014673', '3014674', '3014200', '3014677', '3014686', '3014725', '3014832', '3014845', '3014849', '3014861', '3014865', '3014907', '3014909', '3014960', '3014972', '3014982', '3014983', '3014991', '3015027', '3015029', '3014442', '3015042', '3014976', '3015053', '3015056', '3015080', '3015083', '3015086', '3015087', '3015100', '3015101', '3015122', '3013312', '3015146', '3015152', '3015308', '3015313', '3015314', '3015315', '3015333', '3015356', '3015375', '3015376', '3015378', '3015380', '3015385', '3015389', '3015395', '3015417', '3015429', '3015430', '3015458', '3015476', '3015531', '3015545', '3015549', '3015579', '3015596', '3015599', '3015602', '3015603', '3015604', '3015629', '3015681', '3015712', '3015764', '3015765', '3015787', '3015798', '3015800', '3015822', '3015831', '3015836', '3015843', '3015880', '3015893', '3015926', '3015925', '3015930', '3015931', '3015937', '3015950', '3016020', '3016035', '3016043', '3013940', '3016080', '3016115', '3016147', '3016151', '3016177', '3016178', '3016120', '3016055', '3016273', '3016311', '3016317', '3016318', '3016324', '3016327', '3016329', '3016343', '3016356', '3016357', '3016370', '3014446', '3016380', '3016381', '3016383', '3016384', '3016363', '3016392', '3016407', '3016408', '3016409', '3016452', '3016453', '3016450')) AND (s.city_id = '1398') ORDER BY `s`.`is_charged` DESC, `s`.`score` DESC LIMIT 20
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
s |
range |
PRIMARY,city_id |
city_id |
9 |
|
195 |
Using index condition; Using where; Using filesort |
|