SQL Query Log (19 queries)
1.
2.41ms
select * from `hostel_settings` limit 1
2.
0.35ms
select * from `sms_email_settings` limit 1
3.
0.38ms
select * from `notices` where `is_published` = ? and `publish_date` <= ? and (`expiry_date` is null or `expiry_date` >= ?) order by `publish_date` desc limit 5
4.
0.26ms
select * from `events` where `is_published` = ? and `event_date` >= ? order by `event_date` asc limit 5
5.
0.41ms
select `blocks`.*, (select count(*) from `rooms` where `blocks`.`id` = `rooms`.`block_id`) as `total_beds` from `blocks` where `is_active` = ?
6.
0.24ms
select count(*) as aggregate from `students` where `block_id` = ? and `is_active` = ? and `students`.`deleted_at` is null
7.
0.18ms
select count(*) as aggregate from `students` where `block_id` = ? and `is_active` = ? and `students`.`deleted_at` is null
8.
0.17ms
select count(*) as aggregate from `students` where `block_id` = ? and `is_active` = ? and `students`.`deleted_at` is null
9.
0.34ms
select * from `hostel_settings` limit 1
10.
0.31ms
select * from `academic_years` where `is_active` = ? and `academic_years`.`deleted_at` is null limit 1
11.
0.47ms
select * from `admission_settings` where `academic_year_id` = ? and `is_admission_open` = ? limit 1
12.
0.39ms
select * from `galleries` where `category` = ? and `is_active` = ? order by `sort_order` asc
13.
0.31ms
select * from `sms_email_settings` limit 1
14.
0.32ms
select * from `galleries` where `category` = ? and `is_active` = ? limit 1
15.
0.40ms
select * from `galleries` where `category` = ? and `is_active` = ? limit 1
16.
0.27ms
select * from `galleries` where `category` = ? and `is_active` = ? limit 1
17.
0.26ms
select * from `academic_years` where `is_active` = ? and `academic_years`.`deleted_at` is null limit 1
18.
0.30ms
select * from `admission_settings` where `academic_year_id` = ? and `is_admission_open` = ? limit 1
19.
0.29ms
select * from `site_popups` where `is_active` = ? order by `created_at` desc limit 1
