| 0.0003 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0004 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 784036 LIMIT 1
|
| 0.0009 |
SELECT * FROM `employers` WHERE `employer_id` = 482630 LIMIT 1
|
| 0.0191 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 784036 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-15',ej.date_added) duration_days, DATEDIFF('2026-04-15',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-15',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '784036'
|
| 0.0008 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 784036
|
| 0.0033 |
UPDATE employer_jobs SET hit_counts = '***Apr-26-2022=62***Apr-27-2022=10***Apr-29-2022=8***Apr-30-2022=4***May-01-2022=3***May-02-2022=6***May-03-2022=5***May-05-2022=3***May-06-2022=3***May-09-2022=1***May-10-2022=1***May-12-2022=1***May-15-2022=1***May-16-2022=4***May-18-2022=1***May-22-2022=1***May-23-2022=1***May-24-2022=1***May-26-2022=2***May-28-2022=1***May-29-2022=1***Jun-01-2022=1***Jun-03-2022=2***Jun-08-2022=1***Jun-13-2022=1***Jun-15-2022=1***Jun-16-2022=1***Jun-17-2022=1***Jun-18-2022=1***Jun-23-2022=1***Jun-27-2022=2***Jun-28-2022=1***Jun-30-2022=2***Jul-04-2022=1***Jul-05-2022=1***Jul-09-2022=1***Jul-12-2022=4***Jul-14-2022=1***Jul-15-2022=1***Jul-17-2022=1***Jul-19-2022=1***Jul-20-2022=1***Jul-21-2022=2***Jul-23-2022=1***Jul-24-2022=2***Jul-26-2022=4***Aug-02-2022=2***Aug-03-2022=2***Aug-06-2022=1***Aug-09-2022=2***Aug-13-2022=2***Aug-14-2022=1***Aug-15-2022=1***Aug-20-2022=1***Aug-29-2022=2***Aug-31-2022=1***Sep-01-2022=1***Sep-07-2022=3***Sep-08-2022=1***Sep-09-2022=1***Sep-10-2022=1***Sep-12-2022=2***Sep-13-2022=2***Sep-18-2022=1***Sep-19-2022=1***Sep-21-2022=2***Sep-23-2022=2***Sep-28-2022=2***Oct-03-2022=2***Oct-05-2022=1***Oct-08-2022=2***Oct-09-2022=4***Oct-11-2022=2***Oct-12-2022=2***Oct-13-2022=3***Oct-14-2022=3***Oct-15-2022=2***Oct-17-2022=2***Oct-18-2022=3***Oct-20-2022=1***Oct-21-2022=1***Oct-25-2022=1***Oct-28-2022=1***Oct-29-2022=1***Oct-31-2022=1***Nov-02-2022=1***Nov-03-2022=2***Nov-07-2022=2***Nov-12-2022=1***Nov-13-2022=1***Nov-14-2022=1***Nov-15-2022=1***Nov-16-2022=1***Nov-17-2022=2***Nov-19-2022=2***Nov-22-2022=3***Nov-23-2022=2***Nov-27-2022=1***Nov-29-2022=1***Dec-01-2022=61***Dec-02-2022=26***Dec-03-2022=4***Dec-04-2022=8***Dec-05-2022=7***Dec-06-2022=6***Dec-07-2022=8***Dec-08-2022=1***Dec-09-2022=3***Dec-10-2022=2***Dec-11-2022=2***Dec-12-2022=2***Dec-13-2022=2***Dec-14-2022=2***Dec-15-2022=9***Dec-16-2022=9***Dec-18-2022=8***Dec-19-2022=2***Dec-20-2022=6***Dec-21-2022=2***Dec-22-2022=8***Dec-23-2022=1***Dec-24-2022=2***Dec-25-2022=1***Dec-26-2022=4***Dec-27-2022=3***Dec-28-2022=1***Dec-30-2022=1***Dec-31-2022=2***Jan-01-2023=2***Jan-02-2023=1***Jan-03-2023=9***Jan-04-2023=2***Jan-05-2023=2***Jan-07-2023=1***Jan-09-2023=2***Jan-10-2023=3***Jan-11-2023=2***Jan-12-2023=5***Jan-14-2023=2***Jan-15-2023=1***Jan-16-2023=3***Jan-17-2023=3***Jan-21-2023=1***Jan-23-2023=3***Jan-24-2023=4***Jan-25-2023=2***Jan-26-2023=3***Jan-27-2023=1***Jan-28-2023=2***Jan-29-2023=1***Jan-30-2023=1***Feb-01-2023=1***Feb-02-2023=5***Feb-03-2023=2***Feb-06-2023=2***Feb-07-2023=1***Feb-08-2023=1***Feb-13-2023=6***Feb-16-2023=1***Feb-17-2023=1***Feb-19-2023=1***Feb-21-2023=1***Feb-22-2023=1***Feb-23-2023=1***Feb-25-2023=1***Feb-27-2023=1***Mar-01-2023=1***Mar-02-2023=1***Mar-03-2023=1***Mar-06-2023=1***Mar-07-2023=2***Mar-08-2023=1***Mar-09-2023=3***Mar-10-2023=3***Mar-12-2023=1***Mar-13-2023=1***Mar-14-2023=3***Mar-15-2023=1***Mar-16-2023=1***Mar-17-2023=1***Mar-19-2023=2***Mar-20-2023=4***Mar-21-2023=1***Mar-22-2023=1***Mar-23-2023=2***Mar-24-2023=1***Mar-25-2023=2***Mar-27-2023=1***Mar-28-2023=2***Mar-29-2023=1***Mar-30-2023=2***Mar-31-2023=1***Apr-01-2023=1***Apr-02-2023=2***Apr-03-2023=4***Apr-05-2023=1***Apr-18-2023=1***Apr-19-2023=1***May-04-2023=1***May-05-2023=1***May-06-2023=1***May-10-2023=1***May-11-2023=1***May-15-2023=1***May-17-2023=1***May-18-2023=1***May-22-2023=1***May-25-2023=2***May-28-2023=1***May-29-2023=1***May-30-2023=3***Jun-02-2023=2***Jun-05-2023=1***Jun-12-2023=1***Jun-23-2023=1***Jun-26-2023=3***Jun-27-2023=1***Jun-30-2023=1***Jul-01-2023=1***Jul-04-2023=1***Jul-05-2023=1***Jul-11-2023=3***Jul-13-2023=1***Jul-19-2023=3***Jul-25-2023=2***Jul-27-2023=1***Jul-28-2023=1***Aug-06-2023=1***Aug-08-2023=1***Aug-10-2023=1***Aug-16-2023=2***Aug-18-2023=2***Aug-21-2023=3***Aug-23-2023=2***Aug-30-2023=2***Sep-04-2023=1***Sep-05-2023=1***Sep-06-2023=2***Sep-08-2023=1***Sep-11-2023=1***Sep-13-2023=2***Sep-14-2023=2***Sep-15-2023=2***Sep-17-2023=1***Sep-19-2023=1***Sep-20-2023=3***Sep-26-2023=1***Sep-27-2023=1***Sep-28-2023=1***Oct-04-2023=1***Oct-07-2023=2***Oct-09-2023=2***Oct-10-2023=1***Oct-11-2023=1***Oct-15-2023=2***Oct-18-2023=3***Oct-22-2023=5***Oct-25-2023=2***Oct-27-2023=1***Oct-28-2023=3***Nov-01-2023=1***Nov-08-2023=1***Nov-11-2023=1***Nov-17-2023=1***Nov-18-2023=1***Nov-20-2023=1***Nov-21-2023=44***Nov-22-2023=46***Nov-23-2023=10***Nov-24-2023=7***Nov-25-2023=7***Nov-26-2023=4***Nov-27-2023=5***Nov-28-2023=3***Nov-29-2023=4***Nov-30-2023=1***Dec-01-2023=4***Dec-02-2023=1***Dec-03-2023=5***Dec-04-2023=4***Dec-05-2023=3***Dec-06-2023=1***Dec-08-2023=1***Dec-09-2023=2***Dec-12-2023=3***Dec-13-2023=1***Dec-15-2023=1***Dec-19-2023=3***Dec-20-2023=1***Dec-21-2023=3***Dec-22-2023=5***Dec-23-2023=2***Dec-24-2023=4***Dec-25-2023=4***Dec-26-2023=2***Dec-27-2023=6***Dec-28-2023=3***Dec-29-2023=4***Dec-30-2023=2***Dec-31-2023=2***Jan-01-2024=2***Jan-03-2024=4***Jan-04-2024=2***Jan-08-2024=2***Jan-11-2024=1***Jan-15-2024=1***Jan-16-2024=1***Jan-18-2024=1***Jan-25-2024=1***Jan-29-2024=1***Feb-07-2024=3***Feb-08-2024=1***Feb-10-2024=2***Feb-11-2024=4***Feb-12-2024=1***Feb-13-2024=4***Feb-15-2024=1***Feb-16-2024=1***Feb-17-2024=1***Feb-19-2024=1***Feb-20-2024=3***Feb-22-2024=1***Feb-26-2024=1***Feb-29-2024=1***Mar-07-2024=1***Mar-08-2024=2***Mar-12-2024=1***Mar-20-2024=4***Mar-22-2024=1***Mar-27-2024=2***Apr-03-2024=1***Apr-10-2024=2***Apr-11-2024=1***Apr-13-2024=2***Apr-16-2024=2***Apr-18-2024=4***May-04-2024=1***May-17-2024=2***May-20-2024=1***May-28-2024=2***May-29-2024=2***Jun-01-2024=3***Jun-11-2024=1***Jun-12-2024=2***Jun-18-2024=1***Jun-20-2024=1***Jun-27-2024=2***Jun-28-2024=1***Jun-29-2024=1***Jul-06-2024=3***Jul-09-2024=1***Jul-15-2024=1***Jul-16-2024=2***Jul-19-2024=1***Jul-23-2024=2***Jul-24-2024=1***Jul-27-2024=2***Aug-16-2024=1***Aug-20-2024=1***Sep-05-2024=1***Sep-12-2024=1***Sep-14-2024=2***Sep-17-2024=1***Sep-27-2024=2***Sep-29-2024=1***Oct-01-2024=1***Oct-07-2024=1***Oct-28-2024=4***Oct-30-2024=1***Nov-06-2024=1***Dec-20-2024=2***Jan-11-2025=1***Jan-12-2025=1***Jan-16-2025=113***Jan-17-2025=17***Jan-18-2025=8***Jan-19-2025=5***Jan-20-2025=17***Jan-21-2025=15***Jan-22-2025=17***Jan-23-2025=18***Jan-24-2025=3***Jan-25-2025=2***Jan-26-2025=5***Jan-27-2025=8***Jan-28-2025=2***Jan-29-2025=3***Jan-30-2025=4***Jan-31-2025=2***Feb-01-2025=1***Feb-03-2025=10***Feb-04-2025=5***Feb-05-2025=2***Feb-06-2025=12***Feb-07-2025=6***Feb-08-2025=3***Feb-11-2025=1***Feb-12-2025=5***Feb-13-2025=4***Feb-14-2025=4***Feb-15-2025=1***Feb-16-2025=4***Feb-17-2025=3***Feb-18-2025=5***Feb-19-2025=5***Feb-20-2025=2***Feb-21-2025=9***Feb-22-2025=9***Feb-23-2025=2***Feb-24-2025=3***Feb-25-2025=3***Feb-26-2025=3***Feb-27-2025=4***Mar-01-2025=1***Mar-03-2025=2***Mar-06-2025=5***Mar-10-2025=2***Mar-11-2025=2***Mar-14-2025=3***Mar-18-2025=1***Mar-21-2025=1***Mar-25-2025=2***Mar-27-2025=6***Mar-28-2025=1***Mar-29-2025=5***Mar-31-2025=3***Apr-03-2025=1***Apr-04-2025=1***Apr-05-2025=2***Apr-06-2025=1***Apr-07-2025=1***Apr-08-2025=2***Apr-11-2025=1***Apr-16-2025=1***Apr-17-2025=4***Apr-18-2025=5***Apr-21-2025=2***Apr-23-2025=1***Apr-25-2025=3***Apr-29-2025=1***Apr-30-2025=2***May-02-2025=1***May-07-2025=2***May-08-2025=1***May-14-2025=1***May-20-2025=6***May-21-2025=2***May-24-2025=1***May-27-2025=1***May-28-2025=1***May-29-2025=1***Jun-02-2025=1***Jun-04-2025=5***Jun-05-2025=1***Jun-09-2025=1***Jun-27-2025=2***Jun-28-2025=1***Jul-03-2025=1***Jul-09-2025=1***Jul-12-2025=3***Jul-13-2025=1***Jul-14-2025=1***Jul-16-2025=1***Jul-17-2025=1***Jul-19-2025=3***Jul-20-2025=1***Jul-21-2025=1***Jul-22-2025=2***Jul-23-2025=2***Jul-25-2025=3***Jul-28-2025=1***Jul-30-2025=2***Aug-03-2025=1***Aug-07-2025=2***Aug-09-2025=2***Aug-11-2025=2***Aug-13-2025=1***Aug-15-2025=2***Aug-17-2025=1***Aug-21-2025=1***Aug-22-2025=1***Aug-23-2025=1***Aug-30-2025=1***Sep-03-2025=1***Sep-04-2025=1***Sep-05-2025=3***Sep-11-2025=1***Sep-12-2025=1***Sep-13-2025=1***Sep-14-2025=1***Sep-15-2025=1***Sep-18-2025=1***Sep-21-2025=1***Sep-25-2025=1***Sep-27-2025=1***Sep-28-2025=1***Sep-30-2025=3***Oct-02-2025=3***Oct-03-2025=2***Oct-08-2025=1***Oct-13-2025=1***Oct-15-2025=1***Oct-16-2025=1***Oct-17-2025=1***Oct-21-2025=1***Oct-22-2025=1***Oct-27-2025=2***Oct-29-2025=1***Oct-31-2025=1***Nov-03-2025=3***Nov-11-2025=1***Nov-13-2025=1***Nov-15-2025=1***Nov-17-2025=2***Nov-19-2025=1***Nov-25-2025=1***Nov-27-2025=1***Nov-30-2025=4***Dec-01-2025=5***Dec-03-2025=1***Dec-04-2025=1***Dec-05-2025=1***Dec-06-2025=1***Dec-10-2025=2***Dec-15-2025=1***Dec-17-2025=4***Dec-18-2025=1***Dec-22-2025=1***Dec-23-2025=1***Dec-25-2025=1***Dec-26-2025=2***Dec-30-2025=1***Dec-31-2025=1***Jan-01-2026=2***Jan-02-2026=1***Jan-06-2026=3***Jan-07-2026=1***Jan-09-2026=1***Jan-10-2026=4***Jan-11-2026=1***Jan-16-2026=1***Jan-18-2026=2***Jan-19-2026=1***Jan-21-2026=1***Jan-23-2026=3***Jan-25-2026=1***Jan-27-2026=4***Jan-30-2026=1***Jan-31-2026=2***Feb-01-2026=3***Feb-06-2026=1***Feb-08-2026=2***Feb-10-2026=1***Feb-11-2026=1***Feb-12-2026=1***Feb-16-2026=1***Mar-01-2026=4***Mar-03-2026=2***Mar-07-2026=1***Mar-09-2026=3***Mar-10-2026=1***Mar-11-2026=23***Mar-12-2026=33***Mar-13-2026=11***Mar-14-2026=3***Mar-15-2026=6***Mar-16-2026=11***Mar-17-2026=14***Mar-18-2026=6***Mar-19-2026=7***Mar-20-2026=1***Mar-21-2026=3***Mar-23-2026=1***Mar-24-2026=5***Mar-25-2026=1***Mar-26-2026=5***Mar-27-2026=2***Mar-28-2026=1***Mar-29-2026=1***Mar-30-2026=1***Mar-31-2026=5***Apr-01-2026=32***Apr-02-2026=20***Apr-03-2026=1***Apr-05-2026=1***Apr-06-2026=2***Apr-07-2026=4***Apr-08-2026=1***Apr-09-2026=1***Apr-10-2026=1***Apr-15-2026=1' WHERE job_id= '784036'
|
| 0.0008 |
UPDATE employer_jobs SET monthly_hits = '***Apr-2022=84***May-2022=36***Jun-2022=15***Jul-2022=21***Aug-2022=15***Sep-2022=19***Oct-2022=32***Nov-2022=21***Dec-2022=193***Jan-2023=56***Feb-2023=26***Mar-2023=41***Apr-2023=10***May-2023=16***Jun-2023=10***Jul-2023=14***Aug-2023=14***Sep-2023=20***Oct-2023=23***Nov-2023=137***Dec-2023=67***Jan-2024=16***Feb-2024=25***Mar-2024=11***Apr-2024=12***May-2024=8***Jun-2024=12***Jul-2024=13***Aug-2024=2***Sep-2024=8***Oct-2024=7***Nov-2024=1***Dec-2024=2***Jan-2025=241***Feb-2025=106***Mar-2025=34***Apr-2025=28***May-2025=17***Jun-2025=11***Jul-2025=24***Aug-2025=15***Sep-2025=18***Oct-2025=16***Nov-2025=15***Dec-2025=24***Jan-2026=29***Feb-2026=10***Mar-2026=151***Apr-2026=64' WHERE job_id= '784036'
|
| 0.0019 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '784036' 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` = 784036
|
| 0.0022 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '482630' AND `date_added` >= '2022-06-08'
|
| 0.0003 |
select * from teasers
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='9'
|
| 0.0012 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='101' AND skill_cat_id ='9'
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='101' AND skill_cat_id ='9'
|