| 0.0005 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0006 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 454123 LIMIT 1
|
| 0.0005 |
SELECT * FROM `employers` WHERE `employer_id` = 391929 LIMIT 1
|
| 0.0040 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 454123 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-09-05',ej.date_added) duration_days, DATEDIFF('2026-09-05',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-09-05',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '454123'
|
| 0.0009 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 454123
|
| 0.0010 |
UPDATE employer_jobs SET hit_counts = '***Oct-06-2020=55***Oct-07-2020=9***Oct-08-2020=9***Oct-09-2020=2***Oct-10-2020=2***Oct-11-2020=1***Oct-13-2020=2***Oct-15-2020=62***Oct-16-2020=24***Oct-17-2020=10***Oct-18-2020=3***Oct-19-2020=6***Oct-20-2020=2***Oct-21-2020=7***Oct-24-2020=2***Oct-25-2020=2***Oct-27-2020=2***Oct-28-2020=1***Nov-01-2020=1***Nov-03-2020=2***Nov-08-2020=1***Nov-14-2020=1***Dec-13-2020=1***Jan-25-2021=2***Jan-29-2021=2***Feb-18-2021=2***Feb-24-2021=1***Apr-26-2021=1***May-10-2021=1***Aug-08-2021=1***Aug-12-2021=1***Oct-10-2021=1***May-15-2022=1***Jun-08-2022=1***Dec-09-2023=1***Sep-09-2024=1***Aug-17-2025=2***Jan-26-2026=1***Feb-04-2026=1***Feb-11-2026=1***Feb-20-2026=1***Feb-21-2026=1***Mar-19-2026=1***Apr-26-2026=1***Apr-29-2026=1***Jul-06-2026=1***Jul-15-2026=533***Jul-16-2026=26***Jul-17-2026=13***Jul-18-2026=4***Jul-19-2026=1***Jul-20-2026=5***Jul-21-2026=5***Jul-22-2026=2***Jul-23-2026=8***Jul-24-2026=6***Jul-25-2026=1***Jul-27-2026=1***Jul-28-2026=1***Jul-29-2026=3***Jul-30-2026=1***Jul-31-2026=1***Aug-01-2026=1***Aug-06-2026=2***Aug-09-2026=1***Aug-20-2026=1***Aug-22-2026=2***Sep-05-2026=1' WHERE job_id= '454123'
|
| 0.0009 |
UPDATE employer_jobs SET monthly_hits = '***Oct-2020=201***Nov-2020=5***Dec-2020=1***Jan-2021=4***Feb-2021=3***Apr-2021=1***May-2021=1***Aug-2021=2***Oct-2021=1***May-2022=1***Jun-2022=1***Dec-2023=1***Sep-2024=1***Aug-2025=2***Jan-2026=1***Feb-2026=4***Mar-2026=1***Apr-2026=2***Jul-2026=611***Aug-2026=7***Sep-2026=1' WHERE job_id= '454123'
|
| 0.0024 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '454123' 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` = 454123
|
| 0.0083 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '391929' AND `date_added` >= '2022-06-08'
|
| 0.0005 |
select * from teasers
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='14'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='137' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='9' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='137' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='9' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='3'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='137' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='9' AND skill_cat_id ='3'
|