23 |
0.000677 |
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 ('3013182', '3013187', '3013188', '3013189', '3013230', '3013236', '3013254', '3013256', '3013265', '3013266', '3013269', '3013311', '3013316', '3013327', '3013361', '3013429', '3013450', '3013459', '3013467', '3013469', '3013474', '3013490', '3013504', '3013519', '3013534', '3013540', '3013947', '3013959', '3013960', '3013996', '3013997', '3014015', '3014022', '3014047', '3014052', '3014069', '3014096', '3014099', '3014134', '3014151', '3014171', '3014180', '3014202', '3014234', '3014235', '3014236', '3014237', '3014238', '3014239', '3014240', '3014241', '3014242', '3014243', '3014244', '3014247', '3014193', '3014295', '3014313', '3014298', '3014316', '3014333', '3014423', '3014428', '3014429', '3014439', '3014445', '3014487', '3014553', '3014583', '3014584', '3014595', '3014615', '3014618', '3014637', '3014647', '3014705', '3014697', '3014832', '3014834', '3014846', '3014848', '3014849', '3014861', '3014867', '3014882', '3014890', '3014909', '3014923', '3014934', '3014977', '3015034', '3015053', '3015059', '3015203', '3015265', '3015304', '3015305', '3015365', '3015387', '3015388', '3015396', '3015454', '3015456', '3014644', '3015471', '3015494', '3015495', '3015531', '3015551', '3015674', '3014802', '3015715', '3015718', '3015729', '3015607', '3015793', '3015834', '3015880', '3015965', '3015989', '3015990', '3016030', '3016051', '3016082', '3016146', '3016147', '3016241', '3016243', '3016328', '3016359', '3016360', '3016420', '3015991')) 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 |
|
1 |
Using where |
|
24 |
0.000747 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013182', '3013187', '3013188', '3013189', '3013230', '3013236', '3013254', '3013256', '3013265', '3013266', '3013269', '3013311', '3013316', '3013327', '3013361', '3013429', '3013450', '3013459', '3013467', '3013469', '3013474', '3013490', '3013504', '3013519', '3013534', '3013540', '3013947', '3013959', '3013960', '3013996', '3013997', '3014015', '3014022', '3014047', '3014052', '3014069', '3014096', '3014099', '3014134', '3014151', '3014171', '3014180', '3014202', '3014234', '3014235', '3014236', '3014237', '3014238', '3014239', '3014240', '3014241', '3014242', '3014243', '3014244', '3014247', '3014193', '3014295', '3014313', '3014298', '3014316', '3014333', '3014423', '3014428', '3014429', '3014439', '3014445', '3014487', '3014553', '3014583', '3014584', '3014595', '3014615', '3014618', '3014637', '3014647', '3014705', '3014697', '3014832', '3014834', '3014846', '3014848', '3014849', '3014861', '3014867', '3014882', '3014890', '3014909', '3014923', '3014934', '3014977', '3015034', '3015053', '3015059', '3015203', '3015265', '3015304', '3015305', '3015365', '3015387', '3015388', '3015396', '3015454', '3015456', '3014644', '3015471', '3015494', '3015495', '3015531', '3015551', '3015674', '3014802', '3015715', '3015718', '3015729', '3015607', '3015793', '3015834', '3015880', '3015965', '3015989', '3015990', '3016030', '3016051', '3016082', '3016146', '3016147', '3016241', '3016243', '3016328', '3016359', '3016360', '3016420', '3015991')) 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 |
|
1 |
Using where; Using filesort |
|