首页第一部分需要展示 查询语句: 本周_属于**小区_所有小学生信息被查询次数_前 8 名的排行榜: "SELECT studentId, insertTime, studentName, studentImg FROM studentInfo WHERE studentType=1 AND studentHome LIKE '小区名称%' AND week(insertTime)=week(now()) ORDER BY studentHit DESC LIMIT 15;"
本周_属于**小区_所有初中生信息被查询次数_前 8 名的排行榜: "SELECT studentId, insertTime, studentName, studentImg FROM studentInfo WHERE studentType=2 AND studentHome LIKE '小区名称%' AND week(insertTime)=week(now()) ORDER BY studentHit DESC LIMIT 15;"
本周_属于**小区_所有高中生信息被查询次数_前 8 名的排行榜: "SELECT studentId, insertTime, studentName, studentImg FROM studentInfo WHERE studentType=3 AND studentHome LIKE '小区名称%' AND week(insertTime)=week(now()) ORDER BY studentHit DESC LIMIT 15;"
本周_全省_所有学生信息被查询次数_前 15 名的排行榜: "SELECT studentId, insertTime, studentName, studentImg FROM studentInfo AND week(insertTime)=week(now()) ORDER BY studentHit DESC LIMIT 15;"