23 |
0.000657 |
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 ('3013172', '3013187', '3013188', '3013189', '3013208', '3013230', '3013236', '3013238', '3013256', '3013265', '3013266', '3013293', '3013292', '3013311', '3013425', '3013429', '3013467', '3013474', '3013490', '3013904', '3013947', '3013955', '3013959', '3013960', '3014015', '3014017', '3014022', '3014063', '3014096', '3014099', '3014106', '3014112', '3014134', '3014171', '3014202', '3014206', '3014207', '3014208', '3014226', '3014229', '3014247', '3014295', '3014297', '3014313', '3014316', '3014333', '3014094', '3014423', '3014428', '3014429', '3014441', '3014442', '3014445', '3014394', '3014485', '3014498', '3014526', '3014534', '3014559', '3014573', '3014576', '3014581', '3014583', '3014598', '3014605', '3014617', '3014618', '3014619', '3014646', '3014647', '3014694', '3014705', '3014725', '3014755', '3014771', '3014782', '3014783', '3014793', '3014800', '3014832', '3014849', '3014856', '3014867', '3014882', '3014886', '3014909', '3014976', '3014977', '3014982', '3015030', '3014993', '3014994', '3015010', '3015048', '3015053', '3015070', '3015094', '3015112', '3015156', '3015188', '3015205', '3015286', '3015369', '3015393', '3015396', '3015403', '3015416', '3015451', '3015453', '3015457', '3014644', '3015471', '3015478', '3015488', '3015519', '3015531', '3015545', '3015551', '3015552', '3015562', '3015601', '3015608', '3015635', '3015660', '3015687', '3015689', '3015701', '3015718', '3015765', '3015607', '3015786', '3015792', '3015834', '3014802', '3015880', '3015901', '3015929', '3015939', '3015989', '3015990', '3016030', '3016146', '3016147', '3014425', '3016254', '3016259', '3016080', '3016337', '3016348', '3016360', '3016401', '3016418')) AND (s.id IN ('3015054', '3013201', '3014247', '3014247', '3014247', '3013412', '3015243', '3014987', '3013411', '3013174', '3014370', '3014370', '3014370', '3014551', '3014756', '3014196', '3014857', '3013217', '3014466', '3014819', '3013219', '3015052', '3015213', '3015350', '3015352', '3015426', '3015280', '3015814', '3015893', '3014087', '3015948', '3015315', '3015042', '3014912', '3014542', '3014550', '3015038', '3015090', '3014679', '3014679', '3014679', '3014679', '3014857', '3015243', '3015052', '3015211', '3015213', '3015352', '3015367', '3015280', '3015344', '3015453', '3015701', '3015724', '3015749', '3015823', '3015893', '3015944', '3015091', '3015948', '3016164', '3015970', '3014270', '3015243', '3015038', '3014784', '3015090', '3015241', '3015211', '3015212', '3015213', '3015350', '3015367', '3015453', '3015701', '3015724', '3015749', '3015814', '3015823', '3014087', '3015091', '3015975', '3014912'))
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
s |
range |
PRIMARY |
PRIMARY |
4 |
|
3 |
Using where |
|
24 |
0.000837 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013172', '3013187', '3013188', '3013189', '3013208', '3013230', '3013236', '3013238', '3013256', '3013265', '3013266', '3013293', '3013292', '3013311', '3013425', '3013429', '3013467', '3013474', '3013490', '3013904', '3013947', '3013955', '3013959', '3013960', '3014015', '3014017', '3014022', '3014063', '3014096', '3014099', '3014106', '3014112', '3014134', '3014171', '3014202', '3014206', '3014207', '3014208', '3014226', '3014229', '3014247', '3014295', '3014297', '3014313', '3014316', '3014333', '3014094', '3014423', '3014428', '3014429', '3014441', '3014442', '3014445', '3014394', '3014485', '3014498', '3014526', '3014534', '3014559', '3014573', '3014576', '3014581', '3014583', '3014598', '3014605', '3014617', '3014618', '3014619', '3014646', '3014647', '3014694', '3014705', '3014725', '3014755', '3014771', '3014782', '3014783', '3014793', '3014800', '3014832', '3014849', '3014856', '3014867', '3014882', '3014886', '3014909', '3014976', '3014977', '3014982', '3015030', '3014993', '3014994', '3015010', '3015048', '3015053', '3015070', '3015094', '3015112', '3015156', '3015188', '3015205', '3015286', '3015369', '3015393', '3015396', '3015403', '3015416', '3015451', '3015453', '3015457', '3014644', '3015471', '3015478', '3015488', '3015519', '3015531', '3015545', '3015551', '3015552', '3015562', '3015601', '3015608', '3015635', '3015660', '3015687', '3015689', '3015701', '3015718', '3015765', '3015607', '3015786', '3015792', '3015834', '3014802', '3015880', '3015901', '3015929', '3015939', '3015989', '3015990', '3016030', '3016146', '3016147', '3014425', '3016254', '3016259', '3016080', '3016337', '3016348', '3016360', '3016401', '3016418')) AND (s.id IN ('3015054', '3013201', '3014247', '3014247', '3014247', '3013412', '3015243', '3014987', '3013411', '3013174', '3014370', '3014370', '3014370', '3014551', '3014756', '3014196', '3014857', '3013217', '3014466', '3014819', '3013219', '3015052', '3015213', '3015350', '3015352', '3015426', '3015280', '3015814', '3015893', '3014087', '3015948', '3015315', '3015042', '3014912', '3014542', '3014550', '3015038', '3015090', '3014679', '3014679', '3014679', '3014679', '3014857', '3015243', '3015052', '3015211', '3015213', '3015352', '3015367', '3015280', '3015344', '3015453', '3015701', '3015724', '3015749', '3015823', '3015893', '3015944', '3015091', '3015948', '3016164', '3015970', '3014270', '3015243', '3015038', '3014784', '3015090', '3015241', '3015211', '3015212', '3015213', '3015350', '3015367', '3015453', '3015701', '3015724', '3015749', '3015814', '3015823', '3014087', '3015091', '3015975', '3014912')) 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 |
PRIMARY |
4 |
|
3 |
Using where; Using filesort |
|