| 0.0004 |
SELECT user_level, rebill_date, jobseekers_seen, jobseekers_seen_override from employers WHERE employer_id = ''
|
| 0.0006 |
select * from searches where code = '' limit 1
|
| 0.0579 |
SELECT * FROM skills_categories
|
| 0.0019 |
SELECT j.jobseeker_id, j.name, j.address, j.jobseeker_email, j.last_edit_date, j.picture_filename, j.show_pic, j.facebook, j.id_filename, j.id_approved, j.youtube_status, j.test_IQ, j.test_DISC, j.test_English, jj.hours_per_week, j.date_added, jj.job_description, jj.skill_summary, jj.desired_salary, jj.availability, jj.availability_date, jj.employment_status, jj.employment_type, jj.education, jj.experience, jj.hours_per_day, jj.rate_per_hour FROM jobseekers j INNER JOIN jobseekers_jobdata jj ON (j.jobseeker_id = jj.jobseeker_id) INNER JOIN jobseekers_trust jt ON (j.jobseeker_id = jt.jobseeker_id) WHERE j.status = '1' AND j.approved = 'yes' AND (j.flag_picture = '0' AND j.flag_id = '0' AND j.flag_account = '0') AND trust >= '50' ORDER BY j.last_edit_date DESC LIMIT 0, 30
|
| 0.0003 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0003 |
SELECT * FROM `exrates` WHERE `rate_name` = 'USD-PHP'
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '999152' ORDER BY `jsct`.`rate` DESC
|
| 0.0005 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '2839533' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '147398' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '2948911' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '3254944' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1611979' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '3015391' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1114312' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1189587' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '2256480' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '2555585' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '3934474' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '932929' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '2725676' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '850859' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '2957073' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1423818' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '67568' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '4626901' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1383479' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '3231055' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '4419365' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '3860988' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1984057' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '297630' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1697436' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '286645' ORDER BY `jsct`.`rate` DESC
|
| 0.0004 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1151241' ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '4518070' ORDER BY `jsct`.`rate` DESC
|
| 0.0005 |
SELECT `jsct`.*, `jsct`.`id` as `jsct_id`, `sct`.* FROM `jobseekers_skills_categories` `jsct` LEFT JOIN `skills_categories` `sct` ON `sct`.`id` = `jsct`.`skill_category_id` WHERE `sct`.`is_approved` = 1 AND `jsct`.`jobseeker_id` = '1344847' ORDER BY `jsct`.`rate` DESC
|
| 0.0002 |
SELECT user_level, rebill_date, jobseekers_seen, jobseekers_seen_override from employers WHERE employer_id = ''
|
| 0.0003 |
SELECT * FROM `testimonial_videos` WHERE `placement` = 2 OR `placement` = 0 ORDER BY RAND()
|
| 0.0003 |
select * from teasers
|
| 0.0002 |
SELECT * FROM `exrates` WHERE `base` = 'USD'
|
| 0.0004 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '999152'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '999152'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2839533'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2839533'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '147398'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '147398'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2948911'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2948911'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3254944'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3254944'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1611979'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1611979'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3015391'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3015391'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1114312'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1114312'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1189587'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1189587'
|
| 0.0004 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2256480'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2256480'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2555585'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2555585'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3934474'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3934474'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '932929'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '932929'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2725676'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2725676'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '850859'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '850859'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2957073'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '2957073'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1423818'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1423818'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '67568'
|
| 0.0005 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '67568'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '4626901'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '4626901'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1383479'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1383479'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3231055'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3231055'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '4419365'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '4419365'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3860988'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '3860988'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1984057'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1984057'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '297630'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '297630'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1697436'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1697436'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '286645'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '286645'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1151241'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1151241'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '4518070'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '4518070'
|
| 0.0002 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1344847'
|
| 0.0003 |
SELECT * FROM `jobseekers_trust` WHERE `jobseeker_id` = '1344847'
|