| 0.0003 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0009 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 834561 LIMIT 1
|
| 0.0024 |
SELECT * FROM `employers` WHERE `employer_id` = 237860 LIMIT 1
|
| 0.0028 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 834561 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-14',ej.date_added) duration_days, DATEDIFF('2026-04-14',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-14',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '834561'
|
| 0.0011 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 834561
|
| 0.0030 |
UPDATE employer_jobs SET hit_counts = '***Jul-01-2022=189***Jul-02-2022=18***Jul-03-2022=11***Jul-04-2022=9***Jul-05-2022=4***Jul-07-2022=1***Jul-10-2022=1***Jul-11-2022=2***Jul-12-2022=1***Jul-15-2022=1***Jul-16-2022=4***Jul-23-2022=4***Jul-25-2022=1***Jul-26-2022=3***Jul-28-2022=1***Jul-30-2022=1***Aug-01-2022=1***Aug-03-2022=1***Aug-05-2022=1***Aug-07-2022=1***Aug-10-2022=1***Aug-12-2022=1***Aug-15-2022=1***Aug-16-2022=1***Aug-21-2022=1***Aug-25-2022=1***Aug-27-2022=1***Aug-31-2022=1***Sep-01-2022=1***Sep-06-2022=1***Sep-10-2022=1***Sep-17-2022=1***Sep-28-2022=1***Sep-30-2022=2***Oct-10-2022=1***Oct-13-2022=1***Oct-20-2022=1***Oct-26-2022=1***Oct-28-2022=1***Oct-30-2022=1***Oct-31-2022=1***Nov-01-2022=1***Nov-05-2022=2***Nov-10-2022=1***Nov-20-2022=1***Nov-24-2022=1***Nov-30-2022=1***Dec-07-2022=1***Dec-10-2022=1***Mar-03-2023=4***May-01-2023=1***May-28-2023=1***Jun-03-2023=1***Jun-08-2023=2***Jul-21-2023=2***Sep-08-2023=1***Sep-17-2023=1***Sep-27-2023=1***Oct-03-2023=1***Oct-08-2023=2***Nov-14-2023=1***Feb-03-2024=1***Apr-20-2024=1***May-20-2024=4***May-28-2024=3***Jun-20-2024=2***Jun-22-2024=2***Jun-25-2024=1***Jul-02-2024=2***Jul-03-2024=2***Aug-20-2024=1***Oct-01-2024=2***Jan-15-2025=2***Feb-12-2025=1***Feb-27-2025=1***Mar-01-2025=1***Mar-17-2025=1***Mar-18-2025=1***Mar-29-2025=4***May-13-2025=1***May-18-2025=1***Jun-29-2025=2***Sep-21-2025=1***Oct-31-2025=1***Nov-26-2025=1***Dec-08-2025=1***Feb-11-2026=82***Feb-12-2026=10***Feb-13-2026=2***Feb-14-2026=5***Feb-15-2026=5***Feb-16-2026=2***Feb-17-2026=1***Feb-18-2026=1***Feb-19-2026=27***Feb-20-2026=15***Feb-21-2026=2***Feb-22-2026=2***Feb-23-2026=4***Feb-24-2026=1***Feb-25-2026=1***Feb-27-2026=3***Feb-28-2026=4***Mar-01-2026=3***Mar-04-2026=1***Mar-06-2026=3***Mar-08-2026=2***Mar-10-2026=1***Mar-11-2026=1***Mar-12-2026=1***Mar-13-2026=3***Mar-15-2026=2***Mar-16-2026=2***Mar-17-2026=1***Mar-18-2026=202***Mar-19-2026=12***Mar-20-2026=4***Mar-21-2026=4***Mar-22-2026=10***Mar-23-2026=3***Mar-24-2026=4***Mar-26-2026=2***Mar-27-2026=397***Mar-28-2026=10***Mar-29-2026=16***Mar-30-2026=15***Mar-31-2026=6***Apr-01-2026=9***Apr-02-2026=3***Apr-03-2026=4***Apr-05-2026=3***Apr-06-2026=2***Apr-07-2026=6***Apr-08-2026=1***Apr-09-2026=3***Apr-10-2026=1***Apr-11-2026=1***Apr-14-2026=1' WHERE job_id= '834561'
|
| 0.0007 |
UPDATE employer_jobs SET monthly_hits = '***Jul-2022=251***Aug-2022=12***Sep-2022=7***Oct-2022=7***Nov-2022=7***Dec-2022=2***Mar-2023=4***May-2023=2***Jun-2023=3***Jul-2023=2***Sep-2023=3***Oct-2023=3***Nov-2023=1***Feb-2024=1***Apr-2024=1***May-2024=7***Jun-2024=5***Jul-2024=4***Aug-2024=1***Oct-2024=2***Jan-2025=2***Feb-2025=2***Mar-2025=7***May-2025=2***Jun-2025=2***Sep-2025=1***Oct-2025=1***Nov-2025=1***Dec-2025=1***Feb-2026=167***Mar-2026=704***Apr-2026=34' WHERE job_id= '834561'
|
| 0.0014 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '834561' 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` = 834561
|
| 0.0145 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '237860' AND `date_added` >= '2022-06-08'
|
| 0.0004 |
select * from teasers
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='12'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='124' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='77' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='87' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='124' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='77' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='87' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='124' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='77' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='87' AND skill_cat_id ='8'
|