| 0.0003 |
SELECT *
FROM exrates
WHERE rate_name = 'USD-PHP'
|
| 0.0008 |
SELECT *
FROM `jobseekers`
WHERE `jobseeker_id` = '620406'
LIMIT 1
|
| 0.0042 |
SELECT *
FROM `jobseeker_meta`
WHERE `jobseeker_id` = '620406'
|
| 0.0008 |
SELECT `j`.*, `jj`.*
FROM `jobseekers` `j`
INNER JOIN `jobseekers_jobdata` `jj` ON `j`.`jobseeker_id` = `jj`.`jobseeker_id`
WHERE `j`.`jobseeker_id` = '620406'
|
| 0.0002 |
SELECT *
FROM `jobseekers_trust`
WHERE `jobseeker_id` IS NULL
|
| 0.0003 |
SELECT *
FROM `jobseekers`
WHERE `jobseeker_id` = '620406'
AND `is_private` = 1
|
| 0.0006 |
SELECT *
FROM employment
WHERE jobseeker_id = '620406'
AND hired > -1
|
| 0.0008 |
SELECT
employers.contact_name,
ec.employer_id,
ec.jobseekers_id,
ec.is_jobseeker_reply,
ec.employer_date,
ec.employer_comment,
ec.lastmodified
FROM employers
LEFT JOIN employer_comment ec on employers.employer_id = ec.employer_id
WHERE
ec.jobseekers_id = '620406'
AND employers.deactivate = 0
ORDER BY employer_comment_id DESC
|
| 0.0002 |
SELECT * FROM skill_categories ORDER BY cat_order ASC
|
| 0.0005 |
SELECT * FROM skill_subcategories ORDER BY subcategory ASC
|
| 0.0003 |
SELECT * FROM jobseekers_jobdata WHERE jobseeker_id = 620406 LIMIT 1
|
| 0.0016 |
SELECT * FROM jobseekers_skills WHERE jobseeker_id = 620406 LIMIT 1
|
| 0.0006 |
SELECT * FROM jobseekers j, jobseekers_jobdata jj,jobseekers_skills js WHERE j.jobseeker_id = '620406' AND j.jobseeker_id = jj.jobseeker_id AND jj.jobseeker_id = js.jobseeker_id
|
| 0.0003 |
SELECT *,
DATEDIFF('2026-04-28',rebill_date) duration_rebill
FROM employers WHERE employer_id = '0'
|
| 0.0003 |
SELECT * FROM employer_comment WHERE employer_id = ''
|
| 0.0007 |
SELECT `facebook`, `manual_fb_score`
FROM `jobseekers_trust`
WHERE `jobseeker_id` = '620406'
|
| 0.0024 |
SELECT *
FROM `skills_categories`
WHERE `is_approved` = 1
ORDER BY `name`
|
| 0.0019 |
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` = '620406'
ORDER BY `jsct`.`rate` DESC
|
| 0.0003 |
select * from teasers
|
