| 0.0017 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0014 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 311545 LIMIT 1
|
| 0.0013 |
SELECT * FROM `employers` WHERE `employer_id` = 244298 LIMIT 1
|
| 0.0017 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 311545 AND `misc`.`id` IS NULL
|
| 0.0005 |
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-04-18',ej.date_added) duration_days, DATEDIFF('2026-04-18',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-18',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '311545'
|
| 0.0003 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 311545
|
| 0.0020 |
UPDATE employer_jobs SET hit_counts = '***Jul-01-2019=23***Jul-02-2019=77***Jul-03-2019=18***Jul-04-2019=24***Jul-05-2019=14***Jul-06-2019=4***Jul-07-2019=10***Jul-08-2019=16***Jul-09-2019=7***Jul-10-2019=25***Jul-11-2019=14***Jul-12-2019=7***Jul-13-2019=5***Jul-14-2019=15***Jul-15-2019=15***Jul-16-2019=30***Jul-17-2019=40***Jul-18-2019=12***Jul-19-2019=22***Jul-20-2019=22***Jul-21-2019=8***Jul-22-2019=28***Jul-23-2019=27***Jul-24-2019=23***Jul-25-2019=14***Jul-26-2019=20***Jul-27-2019=21***Jul-28-2019=7***Jul-29-2019=10***Jul-30-2019=27***Jul-31-2019=23***Aug-01-2019=14***Aug-02-2019=20***Aug-03-2019=5***Aug-04-2019=7***Aug-05-2019=12***Aug-06-2019=7***Aug-07-2019=6***Aug-08-2019=12***Aug-09-2019=7***Aug-10-2019=2***Aug-11-2019=2***Aug-12-2019=6***Aug-13-2019=9***Aug-14-2019=15***Aug-15-2019=10***Aug-16-2019=9***Aug-17-2019=3***Aug-18-2019=6***Aug-19-2019=13***Aug-20-2019=8***Aug-21-2019=14***Aug-22-2019=7***Aug-23-2019=1***Aug-24-2019=14***Aug-25-2019=1***Aug-26-2019=6***Aug-27-2019=9***Aug-28-2019=20***Aug-29-2019=11***Aug-30-2019=7***Aug-31-2019=3***Sep-01-2019=4***Sep-02-2019=4***Sep-03-2019=4***Sep-04-2019=9***Sep-05-2019=15***Sep-06-2019=10***Sep-07-2019=13***Sep-08-2019=6***Sep-10-2019=13***Sep-11-2019=4***Sep-12-2019=5***Sep-13-2019=8***Sep-14-2019=3***Sep-15-2019=5***Sep-16-2019=16***Sep-17-2019=12***Sep-18-2019=7***Sep-19-2019=4***Sep-20-2019=3***Sep-21-2019=9***Sep-22-2019=4***Sep-24-2019=3***Sep-25-2019=3***Sep-26-2019=8***Sep-27-2019=2***Sep-28-2019=1***Sep-29-2019=6***Sep-30-2019=14***Oct-01-2019=11***Oct-02-2019=68***Oct-03-2019=119***Oct-04-2019=19***Oct-05-2019=20***Oct-06-2019=4***Oct-07-2019=18***Oct-08-2019=8***Oct-09-2019=8***Oct-10-2019=5***Oct-11-2019=9***Oct-12-2019=4***Oct-13-2019=2***Oct-14-2019=4***Oct-15-2019=1***Oct-16-2019=4***Oct-17-2019=11***Oct-18-2019=6***Oct-19-2019=4***Oct-20-2019=4***Oct-21-2019=7***Oct-22-2019=8***Oct-23-2019=11***Oct-24-2019=5***Oct-25-2019=1***Oct-26-2019=4***Oct-27-2019=1***Oct-28-2019=17***Oct-29-2019=3***Oct-30-2019=1***Oct-31-2019=3***Nov-01-2019=2***Nov-02-2019=5***Nov-03-2019=2***Nov-04-2019=5***Nov-05-2019=4***Nov-06-2019=1***Nov-07-2019=16***Nov-08-2019=4***Nov-09-2019=4***Nov-10-2019=2***Nov-11-2019=2***Nov-12-2019=8***Nov-13-2019=11***Nov-15-2019=5***Nov-17-2019=7***Nov-18-2019=7***Nov-19-2019=5***Nov-20-2019=2***Nov-21-2019=3***Nov-22-2019=6***Nov-23-2019=4***Nov-24-2019=1***Nov-25-2019=4***Nov-26-2019=5***Nov-27-2019=2***Nov-28-2019=2***Nov-29-2019=3***Nov-30-2019=3***Dec-02-2019=1***Dec-03-2019=3***Dec-04-2019=4***Dec-05-2019=4***Dec-06-2019=3***Dec-07-2019=2***Dec-08-2019=1***Dec-09-2019=3***Dec-10-2019=2***Dec-11-2019=4***Dec-12-2019=2***Dec-13-2019=222***Dec-14-2019=29***Dec-15-2019=16***Dec-16-2019=25***Dec-17-2019=15***Dec-18-2019=10***Dec-19-2019=6***Dec-20-2019=7***Dec-21-2019=3***Dec-22-2019=5***Dec-23-2019=2***Dec-24-2019=1***Dec-25-2019=5***Dec-26-2019=3***Dec-27-2019=3***Dec-29-2019=2***Dec-30-2019=1***Dec-31-2019=2***Jan-01-2020=2***Jan-02-2020=9***Jan-03-2020=5***Jan-04-2020=5***Jan-05-2020=3***Jan-06-2020=6***Jan-07-2020=6***Jan-08-2020=9***Jan-09-2020=7***Jan-10-2020=3***Jan-11-2020=3***Jan-12-2020=4***Jan-13-2020=4***Jan-14-2020=4***Jan-15-2020=4***Jan-16-2020=5***Jan-17-2020=9***Jan-18-2020=4***Jan-19-2020=9***Jan-20-2020=8***Jan-21-2020=4***Jan-22-2020=4***Jan-23-2020=3***Jan-24-2020=1***Jan-25-2020=1***Jan-26-2020=4***Jan-28-2020=8***Jan-29-2020=15***Jan-30-2020=7***Jan-31-2020=8***Feb-02-2020=1***Feb-03-2020=3***Feb-04-2020=9***Feb-05-2020=4***Feb-06-2020=2***Feb-07-2020=2***Feb-08-2020=1***Feb-09-2020=3***Feb-10-2020=2***Feb-11-2020=1***Feb-12-2020=1***Feb-13-2020=1***Feb-14-2020=2***Feb-15-2020=3***Feb-16-2020=2***Feb-17-2020=1***Feb-19-2020=1***Feb-20-2020=4***Feb-21-2020=6***Feb-23-2020=5***Feb-24-2020=4***Feb-25-2020=2***Feb-26-2020=4***Feb-27-2020=23***Feb-28-2020=3***Mar-01-2020=3***Mar-02-2020=6***Mar-03-2020=3***Mar-04-2020=18***Mar-05-2020=4***Mar-06-2020=2***Mar-07-2020=3***Mar-08-2020=1***Mar-09-2020=2***Mar-10-2020=2***Mar-11-2020=20***Mar-12-2020=2***Mar-13-2020=1***Mar-14-2020=4***Mar-16-2020=4***Mar-18-2020=3***Mar-19-2020=21***Mar-20-2020=19***Mar-21-2020=18***Mar-22-2020=7***Mar-23-2020=9***Mar-24-2020=7***Mar-25-2020=18***Mar-26-2020=14***Mar-27-2020=11***Mar-28-2020=4***Mar-29-2020=2***Mar-30-2020=4***Mar-31-2020=5***Apr-01-2020=22***Apr-02-2020=18***Apr-03-2020=15***Apr-04-2020=13***Apr-05-2020=1***Apr-06-2020=26***Apr-07-2020=71***Apr-08-2020=28***Apr-09-2020=18***Apr-10-2020=15***Apr-11-2020=20***Apr-12-2020=34***Apr-13-2020=20***Apr-14-2020=14***Apr-15-2020=18***Apr-16-2020=17***Apr-17-2020=25***Apr-18-2020=15***Apr-19-2020=8***Apr-20-2020=8***Apr-21-2020=18***Apr-22-2020=6***Apr-23-2020=10***Apr-24-2020=10***Apr-25-2020=28***Apr-26-2020=16***Apr-27-2020=12***Apr-28-2020=19***Apr-29-2020=6***Apr-30-2020=11***May-01-2020=46***May-02-2020=13***May-03-2020=5***May-04-2020=9***May-05-2020=20***May-06-2020=7***May-07-2020=32***May-08-2020=14***May-09-2020=23***May-10-2020=5***May-11-2020=8***May-12-2020=18***May-13-2020=7***May-14-2020=10***May-15-2020=5***May-16-2020=1***May-17-2020=1***May-18-2020=3***May-19-2020=15***May-20-2020=4***May-21-2020=7***May-22-2020=4***May-23-2020=2***May-24-2020=4***May-25-2020=4***May-26-2020=2***May-27-2020=3***May-28-2020=2***May-29-2020=6***May-30-2020=3***May-31-2020=1***Jun-01-2020=3***Jun-02-2020=3***Jun-03-2020=2***Jun-04-2020=3***Jun-05-2020=3***Jun-06-2020=5***Jun-07-2020=2***Jun-08-2020=6***Jun-09-2020=1***Jun-10-2020=5***Jun-11-2020=1***Jun-12-2020=4***Jun-13-2020=6***Jun-14-2020=1***Jun-15-2020=1***Jun-16-2020=4***Jun-17-2020=1***Jun-18-2020=3***Jun-22-2020=1***Jun-23-2020=9***Jun-24-2020=3***Jun-25-2020=4***Jun-26-2020=8***Jun-27-2020=1***Jun-28-2020=6***Jun-29-2020=3***Jun-30-2020=6***Jul-01-2020=5***Jul-02-2020=4***Jul-03-2020=5***Jul-05-2020=4***Jul-06-2020=3***Jul-07-2020=9***Jul-08-2020=8***Jul-09-2020=3***Jul-10-2020=1***Jul-11-2020=2***Jul-12-2020=10***Jul-13-2020=6***Jul-14-2020=3***Jul-15-2020=2***Jul-16-2020=5***Jul-17-2020=6***Jul-18-2020=4***Jul-19-2020=8***Jul-20-2020=2***Jul-21-2020=7***Jul-22-2020=1***Jul-23-2020=4***Jul-24-2020=2***Jul-25-2020=6***Jul-26-2020=2***Jul-28-2020=1***Jul-29-2020=5***Jul-30-2020=2***Aug-03-2020=2***Aug-04-2020=3***Aug-05-2020=6***Aug-06-2020=3***Aug-07-2020=1***Aug-08-2020=3***Aug-10-2020=6***Aug-11-2020=1***Aug-12-2020=4***Aug-13-2020=5***Aug-14-2020=6***Aug-15-2020=3***Aug-16-2020=2***Aug-17-2020=1***Aug-18-2020=3***Aug-19-2020=3***Aug-20-2020=2***Aug-23-2020=1***Aug-24-2020=2***Aug-25-2020=4***Aug-26-2020=7***Aug-29-2020=1***Aug-30-2020=2***Aug-31-2020=4***Sep-01-2020=1***Sep-02-2020=4***Sep-03-2020=3***Sep-04-2020=3***Sep-05-2020=1***Sep-06-2020=1***Sep-07-2020=2***Sep-09-2020=1***Sep-11-2020=2***Sep-12-2020=1***Sep-14-2020=1***Sep-15-2020=1***Sep-16-2020=2***Sep-17-2020=3***Sep-18-2020=1***Sep-21-2020=5***Sep-22-2020=2***Sep-23-2020=2***Sep-24-2020=1***Sep-25-2020=1***Sep-26-2020=1***Sep-27-2020=1***Sep-28-2020=6***Sep-29-2020=3***Sep-30-2020=3***Oct-01-2020=6***Oct-03-2020=1***Oct-04-2020=4***Oct-05-2020=1***Oct-08-2020=1***Oct-09-2020=1***Oct-10-2020=2***Oct-16-2020=1***Oct-17-2020=3***Oct-18-2020=1***Oct-21-2020=3***Oct-22-2020=1***Oct-25-2020=1***Oct-26-2020=1***Oct-31-2020=13***Nov-01-2020=7***Nov-02-2020=11***Nov-03-2020=5***Nov-04-2020=7***Nov-05-2020=2***Nov-06-2020=4***Nov-07-2020=5***Nov-09-2020=2***Nov-12-2020=2***Nov-16-2020=1***Nov-18-2020=2***Nov-20-2020=2***Nov-21-2020=2***Nov-25-2020=1***Nov-27-2020=2***Nov-29-2020=2***Nov-30-2020=12***Dec-01-2020=3***Dec-02-2020=4***Dec-03-2020=6***Dec-04-2020=3***Dec-05-2020=2***Dec-06-2020=1***Dec-07-2020=1***Dec-09-2020=1***Dec-10-2020=2***Dec-11-2020=1***Dec-13-2020=1***Dec-15-2020=2***Dec-17-2020=4***Dec-22-2020=1***Dec-23-2020=1***Dec-27-2020=4***Dec-31-2020=3***Jan-02-2021=2***Jan-04-2021=1***Jan-14-2021=2***Jan-25-2021=1***Jan-27-2021=4***Feb-10-2021=2***Feb-22-2021=1***Feb-25-2021=1***Apr-11-2021=1***Apr-22-2021=2***Apr-26-2021=1***May-02-2021=1***May-13-2021=1***Jun-08-2021=1***Jun-17-2021=1***Jun-23-2021=1***Jul-07-2021=1***Aug-13-2021=1***Sep-24-2021=1***Oct-16-2021=1***Oct-20-2021=1***Nov-11-2021=1***Nov-19-2021=1***Feb-02-2022=1***Feb-03-2022=1***Feb-04-2022=1***Feb-12-2022=1***Feb-18-2022=1***Mar-03-2022=1***Apr-11-2022=2***Jun-06-2022=1***Jun-10-2022=2***Jun-16-2022=1***Jul-22-2022=1***Aug-31-2022=1***Oct-21-2022=1***Jan-18-2023=1***Jan-26-2023=1***Mar-15-2023=1***Apr-11-2023=1***May-05-2023=2***Jun-17-2023=1***Jul-01-2023=1***Jul-04-2023=1***Jul-20-2023=1***Jul-24-2023=1***Aug-04-2023=1***Aug-18-2023=1***Sep-08-2023=1***Sep-18-2023=1***Sep-26-2023=1***Sep-28-2023=1***Oct-09-2023=2***Oct-15-2023=1***Nov-14-2023=1***Jan-24-2024=1***Apr-01-2024=1***Apr-04-2024=1***Apr-19-2024=1***Apr-23-2024=1***May-11-2024=1***Jun-11-2024=1***Aug-13-2024=1***Sep-18-2024=1***Oct-07-2024=1***Nov-28-2024=1***Feb-28-2025=1***Mar-16-2025=1***Sep-02-2025=1***Sep-15-2025=1***Oct-03-2025=1***Oct-18-2025=1***Oct-31-2025=1***Nov-13-2025=1***Nov-25-2025=1***Nov-27-2025=1***Dec-09-2025=1***Dec-17-2025=1***Dec-21-2025=1***Dec-22-2025=1***Jan-07-2026=1***Jan-25-2026=1***Feb-04-2026=1***Mar-04-2026=1***Mar-16-2026=1***Apr-07-2026=731***Apr-08-2026=106***Apr-09-2026=43***Apr-10-2026=48***Apr-11-2026=14***Apr-18-2026=1' WHERE job_id= '311545'
|
| 0.0007 |
UPDATE employer_jobs SET monthly_hits = '***Jul-2019=608***Aug-2019=266***Sep-2019=195***Oct-2019=390***Nov-2019=125***Dec-2019=386***Jan-2020=164***Feb-2020=90***Mar-2020=217***Apr-2020=542***May-2020=284***Jun-2020=95***Jul-2020=120***Aug-2020=75***Sep-2020=52***Oct-2020=40***Nov-2020=69***Dec-2020=40***Jan-2021=10***Feb-2021=4***Apr-2021=4***May-2021=2***Jun-2021=3***Jul-2021=1***Aug-2021=1***Sep-2021=1***Oct-2021=2***Nov-2021=2***Feb-2022=5***Mar-2022=1***Apr-2022=2***Jun-2022=4***Jul-2022=1***Aug-2022=1***Oct-2022=1***Jan-2023=2***Mar-2023=1***Apr-2023=1***May-2023=2***Jun-2023=1***Jul-2023=4***Aug-2023=2***Sep-2023=4***Oct-2023=3***Nov-2023=1***Jan-2024=1***Apr-2024=4***May-2024=1***Jun-2024=1***Aug-2024=1***Sep-2024=1***Oct-2024=1***Nov-2024=1***Feb-2025=1***Mar-2025=1***Sep-2025=2***Oct-2025=3***Nov-2025=3***Dec-2025=4***Jan-2026=2***Feb-2026=1***Mar-2026=2***Apr-2026=943' WHERE job_id= '311545'
|
| 0.0027 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '311545' AND status LIKE 'sent%' ORDER BY id DESC
|
| 0.0003 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 311545
|
| 0.0018 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '244298' AND `date_added` >= '2022-06-08'
|
| 0.0005 |
select * from teasers
|
| 0.0005 |
SELECT * FROM skill_categories WHERE skill_cat_id='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='160' AND skill_cat_id ='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='161' AND skill_cat_id ='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='225' AND skill_cat_id ='2'
|
| 0.0001 |
SELECT * FROM skill_categories WHERE skill_cat_id='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='160' AND skill_cat_id ='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='161' AND skill_cat_id ='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='225' AND skill_cat_id ='2'
|
| 0.0001 |
SELECT * FROM skill_categories WHERE skill_cat_id='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='160' AND skill_cat_id ='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='161' AND skill_cat_id ='2'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='225' AND skill_cat_id ='2'
|