| 0.0006 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0009 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 519787 LIMIT 1
|
| 0.0015 |
SELECT * FROM `employers` WHERE `employer_id` = 227320 LIMIT 1
|
| 0.0045 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 519787 AND `misc`.`id` IS NULL
|
| 0.0006 |
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-10-03',ej.date_added) duration_days, DATEDIFF('2026-10-03',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_jobs ej WHERE e.employer_id = ej.employer_id AND ((e.user_level >= '500' AND ej.date_added <= e.rebill_date) OR e.employer_id = '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-10-03',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '519787'
|
| 0.0008 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 519787
|
| 0.0008 |
UPDATE employer_jobs SET hit_counts = '***Feb-24-2021=14***Feb-25-2021=39***Feb-26-2021=17***Feb-27-2021=9***Feb-28-2021=8***Mar-01-2021=10***Mar-02-2021=6***Mar-03-2021=11***Mar-04-2021=3***Mar-05-2021=3***Mar-06-2021=2***Mar-07-2021=1***Mar-08-2021=4***Mar-09-2021=3***Mar-10-2021=3***Mar-15-2021=1***Mar-17-2021=1***Mar-19-2021=1***Mar-20-2021=1***Mar-21-2021=1***Mar-24-2021=1***Mar-26-2021=1***Mar-31-2021=1***Jul-16-2021=1***Nov-26-2021=1***Apr-05-2022=1***May-30-2022=1***Dec-08-2023=1***Jan-01-2026=1***Jan-08-2026=1***Jan-15-2026=1***Jan-30-2026=1***Feb-06-2026=1***Mar-25-2026=1***Apr-29-2026=1***Jun-18-2026=1***Jul-02-2026=493***Jul-03-2026=72***Jul-04-2026=30***Jul-05-2026=10***Jul-06-2026=45***Jul-07-2026=30***Jul-08-2026=20***Jul-09-2026=7***Jul-10-2026=18***Jul-11-2026=1***Jul-13-2026=4***Jul-14-2026=5***Jul-15-2026=710***Jul-16-2026=77***Jul-17-2026=28***Jul-18-2026=16***Jul-19-2026=10***Jul-20-2026=14***Jul-21-2026=3***Jul-22-2026=9***Jul-23-2026=4***Jul-24-2026=5***Jul-25-2026=2***Jul-26-2026=1***Jul-27-2026=7***Jul-28-2026=5***Jul-29-2026=7***Jul-30-2026=4***Jul-31-2026=2***Aug-01-2026=8***Aug-02-2026=1***Aug-03-2026=1***Aug-05-2026=1***Aug-06-2026=3***Aug-09-2026=3***Aug-11-2026=1***Aug-12-2026=3***Aug-14-2026=1***Aug-15-2026=1***Aug-17-2026=1***Aug-24-2026=4***Aug-25-2026=2***Aug-27-2026=1***Sep-05-2026=1***Sep-08-2026=2***Sep-12-2026=1***Sep-24-2026=1***Sep-27-2026=2***Oct-01-2026=1***Oct-02-2026=745***Oct-03-2026=34' WHERE job_id= '519787'
|
| 0.0006 |
UPDATE employer_jobs SET monthly_hits = '***Feb-2021=87***Mar-2021=54***Jul-2021=1***Nov-2021=1***Apr-2022=1***May-2022=1***Dec-2023=1***Jan-2026=4***Feb-2026=1***Mar-2026=1***Apr-2026=1***Jun-2026=1***Jul-2026=1636***Aug-2026=31***Sep-2026=7***Oct-2026=778' WHERE job_id= '519787'
|
| 0.0036 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '519787' AND status LIKE 'sent%' ORDER BY id DESC
|
| 0.0004 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 519787
|
| 0.0335 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '227320' AND `date_added` >= '2022-06-08'
|
| 0.0004 |
select * from teasers
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='195' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='168' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='195' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='168' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='18'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='18'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='195' AND skill_cat_id ='18'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='168' AND skill_cat_id ='18'
|