MySQL extract this month's record to deepen memory

function Gethotsu ($type =1) {

$model = D (' Plh_click ');
$addtime = Date (' y-m-d ', Time ());
$mounthname = MONTHNAME
if ($type ==1) {

$sql = "Select Cl.click_id,cl.supper_id,cl.add_time from Sc_plh_click as CL WHERE WEEK (' $addtime ', 0) = WEEK (add_time,0) GR OUP by cl.supper_id ORDER by Count (cl.supper_id) desc LIMIT 11 ";

}elseif ($type ==2) {
$sql = "Select Cl.click_id,cl.supper_id,cl.add_time from Sc_plh_click as CL WHERE MONTHNAME (' $addtime ') = MONTHNAME (add_t IME) GROUP by cl.supper_id ORDER by Count (cl.supper_id) desc LIMIT 11 ";
}else{

$sql = "Select Cl.click_id,cl.supper_id,cl.add_time from Sc_plh_click as cl GROUP by cl.supper_id ORDER by Count (Cl.suppe R_ID) desc LIMIT 11 ";
}

MySQL extract this month's record to deepen memory