| 0.0003 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0003 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 388315 LIMIT 1
|
| 0.0004 |
SELECT * FROM `employers` WHERE `employer_id` = 356520 LIMIT 1
|
| 0.0004 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 388315 AND `misc`.`id` IS NULL
|
| 0.0004 |
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-04-21',ej.date_added) duration_days, DATEDIFF('2026-04-21',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-21',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '388315'
|
| 0.0003 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 388315
|
| 0.0010 |
UPDATE employer_jobs SET hit_counts = '***Apr-22-2020=13***Apr-23-2020=10***Apr-24-2020=2***Apr-25-2020=2***Apr-28-2020=4***Apr-29-2020=2***Apr-30-2020=1***May-03-2020=2***May-13-2020=2***May-15-2020=1***May-21-2020=1***May-22-2020=1***May-28-2020=1***May-29-2020=2***May-30-2020=1***Jun-03-2020=2***Jun-05-2020=2***Jun-07-2020=2***Jun-11-2020=1***Jun-14-2020=2***Jun-16-2020=1***Jun-24-2020=2***Jun-26-2020=2***Jun-27-2020=2***Jun-30-2020=3***Jul-01-2020=1***Aug-15-2020=1***Nov-14-2020=1***Nov-16-2020=1***Feb-14-2021=1***Mar-27-2021=1***Apr-09-2021=1***Apr-16-2021=1***May-06-2021=1***May-31-2021=1***Jun-21-2021=1***Jun-27-2021=3***Sep-01-2021=1***Jan-17-2022=1***Feb-04-2022=1***Feb-09-2022=1***Feb-12-2022=1***Mar-03-2022=1***Apr-11-2022=39***Apr-12-2022=1***Apr-21-2022=1***Apr-23-2022=1***Jul-01-2022=1***Jul-23-2022=1***Oct-24-2022=1***Oct-31-2022=1***Dec-18-2022=1***Mar-06-2023=1***May-15-2023=1***May-17-2023=1***Oct-31-2023=1***Dec-17-2023=1***Feb-02-2024=1***Oct-16-2025=88***Oct-17-2025=28***Oct-18-2025=3***Oct-19-2025=3***Oct-20-2025=4***Oct-21-2025=2***Oct-22-2025=1***Oct-23-2025=4***Oct-24-2025=3***Oct-25-2025=2***Oct-26-2025=2***Oct-27-2025=4***Oct-28-2025=1***Oct-29-2025=2***Oct-30-2025=1***Oct-31-2025=2***Nov-01-2025=1***Nov-04-2025=1***Nov-05-2025=1***Nov-07-2025=3***Nov-09-2025=1***Nov-10-2025=1***Nov-12-2025=1***Nov-13-2025=2***Nov-14-2025=1***Nov-16-2025=2***Nov-17-2025=2***Nov-18-2025=1***Nov-19-2025=4***Nov-20-2025=1***Nov-22-2025=2***Nov-25-2025=1***Nov-27-2025=1***Nov-28-2025=1***Dec-01-2025=1***Dec-02-2025=1***Dec-03-2025=2***Dec-04-2025=1***Dec-07-2025=2***Dec-10-2025=2***Dec-11-2025=3***Dec-13-2025=1***Dec-16-2025=2***Dec-19-2025=1***Dec-23-2025=2***Dec-30-2025=89***Dec-31-2025=28***Jan-01-2026=3***Jan-02-2026=4***Jan-03-2026=1***Jan-04-2026=3***Jan-05-2026=3***Jan-06-2026=2***Jan-07-2026=2***Jan-08-2026=1***Jan-09-2026=1***Jan-10-2026=1***Jan-11-2026=3***Jan-12-2026=2***Jan-13-2026=5***Jan-14-2026=1***Jan-15-2026=1***Jan-16-2026=2***Jan-17-2026=2***Jan-18-2026=1***Jan-19-2026=1***Jan-20-2026=1***Jan-21-2026=2***Jan-23-2026=4***Jan-24-2026=1***Jan-25-2026=1***Jan-26-2026=1***Jan-27-2026=2***Jan-29-2026=1***Jan-30-2026=3***Jan-31-2026=1***Feb-02-2026=1***Feb-03-2026=3***Feb-06-2026=1***Feb-08-2026=1***Feb-09-2026=5***Feb-12-2026=1***Feb-15-2026=1***Feb-18-2026=2***Feb-19-2026=4***Feb-22-2026=1***Feb-24-2026=3***Feb-26-2026=1***Mar-01-2026=1***Mar-04-2026=2***Mar-08-2026=1***Mar-09-2026=1***Mar-11-2026=1***Mar-14-2026=1***Mar-17-2026=5***Mar-18-2026=4***Mar-22-2026=3***Mar-23-2026=1***Mar-24-2026=1***Mar-25-2026=1***Mar-27-2026=4***Mar-28-2026=1***Mar-30-2026=1***Apr-01-2026=3***Apr-02-2026=1***Apr-07-2026=11***Apr-09-2026=4***Apr-10-2026=4***Apr-11-2026=2***Apr-13-2026=2***Apr-21-2026=2' WHERE job_id= '388315'
|
| 0.0006 |
UPDATE employer_jobs SET monthly_hits = '***Apr-2020=34***May-2020=11***Jun-2020=19***Jul-2020=1***Aug-2020=1***Nov-2020=2***Feb-2021=1***Mar-2021=1***Apr-2021=2***May-2021=2***Jun-2021=4***Sep-2021=1***Jan-2022=1***Feb-2022=3***Mar-2022=1***Apr-2022=42***Jul-2022=2***Oct-2022=2***Dec-2022=1***Mar-2023=1***May-2023=2***Oct-2023=1***Dec-2023=1***Feb-2024=1***Oct-2025=150***Nov-2025=27***Dec-2025=135***Jan-2026=56***Feb-2026=24***Mar-2026=28***Apr-2026=29' WHERE job_id= '388315'
|
| 0.0003 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '388315' AND status LIKE 'sent%' ORDER BY id DESC
|
| 0.0002 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 388315
|
| 0.0003 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '356520' AND `date_added` >= '2022-06-08'
|
| 0.0003 |
select * from teasers
|
| 0.0009 |
SELECT * FROM skill_categories WHERE 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='138' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' 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='1' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='138' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_categories WHERE skill_cat_id='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='138' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='9'
|