| 0.0003 |
SELECT *
FROM exrates
WHERE rate_name = 'USD-PHP'
|
| 0.0004 |
SELECT *
FROM `jobseekers`
WHERE `jobseeker_id` = '542156'
LIMIT 1
|
| 0.0037 |
SELECT *
FROM `jobseeker_meta`
WHERE `jobseeker_id` = '542156'
|
| 0.0010 |
SELECT `j`.*, `jj`.*
FROM `jobseekers` `j`
INNER JOIN `jobseekers_jobdata` `jj` ON `j`.`jobseeker_id` = `jj`.`jobseeker_id`
WHERE `j`.`jobseeker_id` = '542156'
|
| 0.0002 |
SELECT *
FROM `jobseekers_trust`
WHERE `jobseeker_id` IS NULL
|
| 0.0004 |
SELECT *
FROM `jobseekers`
WHERE `jobseeker_id` = '542156'
AND `is_private` = 1
|
| 0.0003 |
SELECT *
FROM employment
WHERE jobseeker_id = '542156'
AND hired > -1
|
| 0.0003 |
SELECT `employers`.`contact_name`, `employer_comment`.`employer_comment_id`, `employer_comment`.`employer_id`, `employer_comment`.`jobseekers_id`, `employer_comment`.`employer_date`, `employer_comment`.`employer_comment`, `employer_comment`.`lastmodified`, `employer_comment`.`comment_status`
FROM `employers`
LEFT JOIN `employer_comment` ON `employer_comment`.`employer_id` = `employers`.`employer_id`
WHERE `employer_comment`.`jobseekers_id` = '542156'
AND `employers`.`deactivate` = 0
AND `employer_comment`.`comment_status` = 'ACTIVE'
ORDER BY `employer_comment_id` DESC
|
| 0.0004 |
SELECT * FROM skill_categories ORDER BY cat_order ASC
|
| 0.0005 |
SELECT * FROM skill_subcategories ORDER BY subcategory ASC
|
| 0.0002 |
SELECT * FROM jobseekers_jobdata WHERE jobseeker_id = 542156 LIMIT 1
|
| 0.0010 |
SELECT * FROM jobseekers_skills WHERE jobseeker_id = 542156 LIMIT 1
|
| 0.0006 |
SELECT * FROM jobseekers j, jobseekers_jobdata jj,jobseekers_skills js WHERE j.jobseeker_id = '542156' AND j.jobseeker_id = jj.jobseeker_id AND jj.jobseeker_id = js.jobseeker_id
|
| 0.0004 |
SELECT *, DATEDIFF('2026-05-13', rebill_date) AS duration_rebill FROM employers WHERE employer_id = '0'
|
| 0.0003 |
SELECT * FROM employer_comment WHERE employer_id = ''
|
| 0.0011 |
SELECT `facebook`, `manual_fb_score`
FROM `jobseekers_trust`
WHERE `jobseeker_id` = '542156'
|
| 0.0023 |
SELECT *
FROM `skills_categories`
WHERE `is_approved` = 1
ORDER BY `name`
|
| 0.0035 |
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` = '542156'
ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
select * from teasers
|
