| 0.0004 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0004 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 274039 LIMIT 1
|
| 0.0004 |
SELECT * FROM `employers` WHERE `employer_id` = 163611 LIMIT 1
|
| 0.0014 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 274039 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-04-16',ej.date_added) duration_days, DATEDIFF('2026-04-16',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-04-16',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '274039'
|
| 0.0003 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 274039
|
| 0.0012 |
UPDATE employer_jobs SET hit_counts = '***Jan-28-2019=27***Jan-29-2019=201***Jan-30-2019=27***Jan-31-2019=12***Feb-01-2019=7***Feb-02-2019=2***Feb-03-2019=2***Feb-04-2019=2***Feb-05-2019=3***Feb-06-2019=2***Feb-08-2019=1***Feb-09-2019=4***Feb-10-2019=2***Feb-11-2019=1***Feb-12-2019=1***Feb-13-2019=2***Feb-14-2019=5***Feb-15-2019=2***Feb-16-2019=1***Feb-17-2019=1***Feb-18-2019=1***Feb-19-2019=3***Feb-20-2019=2***Feb-21-2019=3***Feb-22-2019=9***Feb-23-2019=12***Feb-24-2019=1***Feb-25-2019=4***Feb-27-2019=5***Feb-28-2019=4***Mar-01-2019=5***Mar-02-2019=1***Mar-03-2019=5***Mar-04-2019=5***Mar-05-2019=3***Mar-06-2019=1***Mar-08-2019=3***Mar-09-2019=6***Mar-10-2019=3***Mar-11-2019=3***Mar-12-2019=1***Mar-13-2019=2***Mar-14-2019=1***Mar-15-2019=2***Mar-16-2019=4***Mar-17-2019=3***Mar-18-2019=2***Mar-19-2019=1***Mar-21-2019=2***Mar-22-2019=3***Mar-23-2019=4***Mar-25-2019=1***Mar-26-2019=1***Mar-27-2019=2***Mar-29-2019=3***Mar-30-2019=3***Mar-31-2019=2***Apr-01-2019=5***Apr-02-2019=3***Apr-03-2019=1***Apr-04-2019=1***Apr-05-2019=1***Apr-06-2019=3***Apr-07-2019=3***Apr-08-2019=2***Apr-09-2019=2***Apr-10-2019=3***Apr-11-2019=1***Apr-12-2019=1***Apr-13-2019=1***Apr-14-2019=1***Apr-15-2019=10***Apr-16-2019=4***Apr-17-2019=2***Apr-18-2019=2***Apr-19-2019=1***Apr-20-2019=1***Apr-21-2019=1***Apr-22-2019=6***Apr-23-2019=2***Apr-24-2019=4***Apr-25-2019=1***Apr-26-2019=2***Apr-27-2019=1***Apr-28-2019=2***Apr-29-2019=2***Apr-30-2019=1***May-01-2019=2***May-02-2019=3***May-03-2019=1***May-04-2019=2***May-05-2019=2***May-06-2019=7***May-07-2019=2***May-08-2019=4***May-09-2019=1***May-10-2019=1***May-11-2019=2***May-12-2019=1***May-15-2019=5***May-16-2019=5***May-18-2019=1***May-19-2019=2***May-20-2019=5***May-21-2019=1***May-22-2019=1***May-23-2019=1***May-24-2019=1***May-30-2019=1***May-31-2019=1***Jun-01-2019=1***Jun-02-2019=1***Jun-03-2019=1***Jun-06-2019=1***Jun-09-2019=1***Jun-12-2019=1***Jun-13-2019=1***Jun-19-2019=1***Jun-24-2019=1***Jun-26-2019=1***Jun-29-2019=1***Jul-19-2019=1***Aug-05-2019=1***Aug-14-2019=1***Aug-20-2019=1***Aug-22-2019=1***Sep-03-2019=1***Sep-07-2019=1***Sep-08-2019=2***Sep-13-2019=1***Sep-14-2019=1***Sep-22-2019=1***Sep-27-2019=1***Sep-28-2019=1***Sep-30-2019=1***Oct-03-2019=1***Oct-04-2019=1***Oct-11-2019=1***Oct-12-2019=2***Oct-16-2019=1***Oct-18-2019=1***Oct-20-2019=1***Oct-22-2019=1***Oct-23-2019=1***Oct-29-2019=1***Nov-03-2019=1***Nov-04-2019=1***Nov-06-2019=1***Nov-13-2019=1***Nov-16-2019=1***Nov-22-2019=1***Dec-03-2019=1***Dec-04-2019=1***Dec-06-2019=1***Dec-08-2019=1***Dec-09-2019=1***Dec-10-2019=2***Dec-11-2019=1***Dec-14-2019=1***Dec-16-2019=2***Dec-17-2019=1***Dec-18-2019=1***Dec-20-2019=1***Dec-21-2019=1***Dec-23-2019=1***Dec-24-2019=1***Jan-01-2020=1***Jan-09-2020=1***Jan-10-2020=1***Jan-12-2020=1***Jan-19-2020=1***Jan-23-2020=1***Feb-03-2020=1***Feb-06-2020=1***Feb-09-2020=1***Feb-10-2020=1***Feb-16-2020=1***Feb-17-2020=1***Mar-02-2020=1***Mar-06-2020=1***Mar-20-2020=1***Mar-28-2020=1***Apr-05-2020=1***Apr-11-2020=1***Apr-17-2020=1***Apr-24-2020=2***Apr-27-2020=1***May-05-2020=1***May-06-2020=1***May-07-2020=1***May-17-2020=1***May-23-2020=1***Jun-04-2020=1***Jun-06-2020=2***Jun-12-2020=1***Jun-18-2020=1***Oct-27-2020=1***Mar-03-2021=1***May-26-2021=1***Jun-18-2021=1***Dec-12-2021=1***Jan-15-2022=1***Feb-08-2022=1***Jun-23-2022=1***Oct-22-2022=1***Jan-13-2023=1***Apr-07-2023=1***Jun-26-2023=1***Jun-28-2023=1***Jul-07-2023=1***Jul-09-2023=1***Sep-19-2023=1***Dec-08-2023=1***Dec-18-2023=1***Oct-01-2025=153***Oct-02-2025=11***Oct-03-2025=10***Oct-04-2025=4***Oct-06-2025=2***Oct-07-2025=2***Oct-08-2025=4***Oct-09-2025=1***Oct-10-2025=1***Oct-12-2025=1***Oct-13-2025=3***Oct-14-2025=3***Oct-15-2025=1***Oct-17-2025=2***Oct-18-2025=2***Oct-20-2025=2***Oct-21-2025=1***Oct-22-2025=1***Oct-27-2025=3***Oct-28-2025=1***Oct-31-2025=1***Nov-02-2025=1***Nov-05-2025=1***Nov-06-2025=1***Nov-12-2025=2***Nov-14-2025=2***Nov-15-2025=1***Nov-17-2025=2***Nov-18-2025=1***Nov-23-2025=1***Nov-24-2025=1***Nov-27-2025=1***Nov-28-2025=3***Nov-30-2025=1***Dec-02-2025=1***Dec-05-2025=1***Dec-07-2025=1***Dec-21-2025=1***Dec-23-2025=1***Dec-25-2025=2***Dec-26-2025=5***Dec-28-2025=1***Dec-30-2025=1***Jan-01-2026=2***Jan-04-2026=1***Jan-05-2026=2***Jan-08-2026=1***Jan-10-2026=3***Jan-11-2026=3***Jan-13-2026=1***Jan-16-2026=1***Jan-19-2026=1***Jan-21-2026=2***Jan-30-2026=1***Feb-02-2026=2***Feb-03-2026=1***Feb-05-2026=1***Feb-11-2026=1***Feb-13-2026=3***Feb-15-2026=2***Feb-16-2026=1***Feb-18-2026=1***Feb-22-2026=1***Feb-27-2026=1***Feb-28-2026=1***Mar-01-2026=2***Mar-02-2026=1***Mar-08-2026=1***Mar-10-2026=1***Mar-17-2026=1***Mar-19-2026=1***Mar-27-2026=2***Apr-01-2026=1***Apr-02-2026=1***Apr-16-2026=1' WHERE job_id= '274039'
|
| 0.0008 |
UPDATE employer_jobs SET monthly_hits = '***Jan-2019=267***Feb-2019=82***Mar-2019=72***Apr-2019=70***May-2019=52***Jun-2019=11***Jul-2019=1***Aug-2019=4***Sep-2019=10***Oct-2019=11***Nov-2019=6***Dec-2019=17***Jan-2020=6***Feb-2020=6***Mar-2020=4***Apr-2020=6***May-2020=5***Jun-2020=5***Oct-2020=1***Mar-2021=1***May-2021=1***Jun-2021=1***Dec-2021=1***Jan-2022=1***Feb-2022=1***Jun-2022=1***Oct-2022=1***Jan-2023=1***Apr-2023=1***Jun-2023=2***Jul-2023=2***Sep-2023=1***Dec-2023=2***Oct-2025=209***Nov-2025=18***Dec-2025=14***Jan-2026=18***Feb-2026=15***Mar-2026=9***Apr-2026=3' WHERE job_id= '274039'
|
| 0.0014 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '274039' 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` = 274039
|
| 0.0028 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '163611' AND `date_added` >= '2022-06-08'
|
| 0.0005 |
select * from teasers
|
| 0.0004 |
SELECT * FROM skill_categories WHERE skill_cat_id='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='136' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='9' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='69' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='202' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='147' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='36' AND skill_cat_id ='1'
|
| 0.0004 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='3' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='37' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='14' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='17' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='136' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='9' AND 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='69' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='202' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='147' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='36' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='3' AND skill_cat_id ='3'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='37' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='14' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='17' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='14'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='136' 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_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='14'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='69' AND skill_cat_id ='14'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='202' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='147' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='36' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='3' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='14'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='37' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='14' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='17' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='15'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='15'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='136' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='9' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='69' AND skill_cat_id ='15'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='202' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='15'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='147' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='36' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='3' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='37' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='14' AND skill_cat_id ='15'
|
| 0.0004 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='17' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='4'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='136' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='9' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='69' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='202' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='147' AND skill_cat_id ='4'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='36' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='3' AND skill_cat_id ='4'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='4'
|
| 0.0005 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='37' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='14' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='17' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='5'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='136' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='9' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='69' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='202' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='147' AND skill_cat_id ='5'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='36' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='3' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='37' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='14' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='17' AND skill_cat_id ='5'
|