/usr/sbin/mysqld, Version: 5.0.51a-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
# Time: 080910  5:30:26
# User@Host: managel_umc[managel_umc] @ localhost []
# Query_time: 11  Lock_time: 0  Rows_sent: 4  Rows_examined: 99
use managel_lcm;
select j.job_id,j.job_title,j.cuntry_id,j.stat_id,j.comp_id,j.exp_from,j.exp_to,j.job_desc,					c.company_name,c.company_url,ct.city_name,st.state_name,coun.country_name,j.job_date,j.job_slug
	 from jobs j,company c,city ct,country coun,states st
	where  j.comp_id=c.rowId and j.stat_id=st.state_id and j.cuntry_id=coun.country_id group by job_id order by job_id desc limit 0,4;
# Time: 080910  5:31:38
# User@Host: hrl_urh[hrl_urh] @ localhost []
# Query_time: 118  Lock_time: 0  Rows_sent: 4  Rows_examined: 564
use hrl_hrdr;
select j.job_id,j.job_title,j.cuntry_id,j.stat_id,j.comp_id,j.exp_from,j.exp_to,j.job_desc,					c.company_name,c.company_url,ct.city_name,st.state_name,coun.country_name,j.job_date,j.job_slug
	 from jobs j,company c,city ct,country coun,states st
	where  j.comp_id=c.rowId and j.stat_id=st.state_id and j.cuntry_id=coun.country_id group by job_id order by job_id desc limit 0,4;
# Time: 080910  5:31:49
# User@Host: hrl_urh[hrl_urh] @ localhost []
# Query_time: 118  Lock_time: 0  Rows_sent: 4  Rows_examined: 564
select j.job_id,j.job_title,j.cuntry_id,j.stat_id,j.comp_id,j.exp_from,j.exp_to,j.job_desc,					c.company_name,c.company_url,ct.city_name,st.state_name,coun.country_name,j.job_date,j.job_slug
	 from jobs j,company c,city ct,country coun,states st
	where  j.comp_id=c.rowId and j.stat_id=st.state_id and j.cuntry_id=coun.country_id group by job_id order by job_id desc limit 0,4;
# Time: 080910  5:48:13
# User@Host: hrl_urh[hrl_urh] @ localhost []
# Query_time: 35  Lock_time: 0  Rows_sent: 4  Rows_examined: 564
select j.job_id,j.job_title,j.cuntry_id,j.stat_id,j.comp_id,j.exp_from,j.exp_to,j.job_desc,					c.company_name,c.company_url,ct.city_name,st.state_name,coun.country_name,j.job_date,j.job_slug
	 from jobs j,company c,city ct,country coun,states st
	where  j.comp_id=c.rowId and j.stat_id=st.state_id and j.cuntry_id=coun.country_id group by job_id order by job_id desc limit 0,4;
# Time: 080910  5:54:46
# User@Host: hrl_urh[hrl_urh] @ localhost []
# Query_time: 37  Lock_time: 0  Rows_sent: 4  Rows_examined: 564
select j.job_id,j.job_title,j.cuntry_id,j.stat_id,j.comp_id,j.exp_from,j.exp_to,j.job_desc,					c.company_name,c.company_url,ct.city_name,st.state_name,coun.country_name,j.job_date,j.job_slug
	 from jobs j,company c,city ct,country coun,states st
	where  j.comp_id=c.rowId and j.stat_id=st.state_id and j.cuntry_id=coun.country_id group by job_id order by job_id desc limit 0,4;
# Time: 080910  5:58:19
# User@Host: hrl_urh[hrl_urh] @ localhost []
# Query_time: 38  Lock_time: 0  Rows_sent: 4  Rows_examined: 564
select j.job_id,j.job_title,j.cuntry_id,j.stat_id,j.comp_id,j.exp_from,j.exp_to,j.job_desc,					c.company_name,c.company_url,ct.city_name,st.state_name,coun.country_name,j.job_date,j.job_slug
	 from jobs j,company c,city ct,country coun,states st
	where  j.comp_id=c.rowId and j.stat_id=st.state_id and j.cuntry_id=coun.country_id group by job_id order by job_id desc limit 0,4;