EntryBoard - Entry Level Jobs and Internships

(default) 15 queries took 9 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `postings`	20	20	1
2	DESCRIBE `companies`	11	11	1
3	DESCRIBE `users`	15	15	1
4	DESCRIBE `interview_recruiters`	4	4	0
5	DESCRIBE `interviews`	9	9	1
6	DESCRIBE `student_profiles`	8	8	1
7	DESCRIBE `schools`	21	21	1
8	DESCRIBE `user_preferences`	4	4	0
9	DESCRIBE `students_educations`	9	9	1
10	DESCRIBE `students_works`	10	10	1
11	DESCRIBE `interviews_props`	11	11	1
12	DESCRIBE `credits`	2	2	0
13	select SQL_CALC_FOUND_ROWS P.id, P.position, P.city, P.state, C.company_name from postings P LEFT JOIN companies C ON (C.id=P.company_id) where P.time_expire > NOW() AND P.status='pub' AND (P.position like '%%' OR P.city like '%%' OR P.state like '%%' OR P.description like '%%' OR C.company_name like '%%') ORDER BY P.time_posted DESC LIMIT 0, 10	0	0	0
14	SELECT FOUND_ROWS() as count;	1	1	0
15	SELECT `Interview`.`id` FROM `interviews` AS `Interview` WHERE `Interview`.`company_id` IS NULL AND `Interview`.`timedate` IS NOT NULL AND NOW() > TIMESTAMPADD(HOUR,-24,`Interview`.`timedate`) AND NOW() < TIMESTAMPADD(HOUR,24,`Interview`.`timedate`) ORDER BY `Interview`.`timedate` ASC	0	0	0

No Results