| 0.0009 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0009 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 283765 LIMIT 1
|
| 0.0009 |
SELECT * FROM `employers` WHERE `employer_id` = 272060 LIMIT 1
|
| 0.0029 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 283765 AND `misc`.`id` IS NULL
|
| 0.0010 |
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-07-13',ej.date_added) duration_days, DATEDIFF('2026-07-13',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-07-13',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '283765'
|
| 0.0015 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 283765
|
| 0.0022 |
UPDATE employer_jobs SET hit_counts = '***Mar-07-2019=106***Mar-08-2019=70***Mar-09-2019=17***Mar-10-2019=20***Mar-11-2019=11***Mar-12-2019=2***Mar-14-2019=1***Mar-15-2019=3***Mar-16-2019=1***Mar-17-2019=4***Mar-18-2019=2***Mar-19-2019=2***Mar-20-2019=2***Mar-22-2019=1***Mar-23-2019=3***Mar-24-2019=4***Mar-25-2019=1***Mar-27-2019=1***Mar-28-2019=2***Mar-29-2019=2***Mar-31-2019=6***Apr-01-2019=4***Apr-02-2019=3***Apr-03-2019=1***Apr-04-2019=2***Apr-05-2019=2***Apr-06-2019=1***Apr-07-2019=1***Apr-09-2019=1***Apr-15-2019=2***Apr-16-2019=1***Apr-17-2019=1***Apr-18-2019=1***Apr-19-2019=1***Apr-22-2019=1***May-04-2019=1***May-06-2019=1***May-14-2019=2***May-16-2019=1***May-19-2019=1***May-27-2019=1***May-30-2019=1***Jun-13-2019=1***Jun-15-2019=1***Jul-03-2019=1***Jul-06-2019=1***Jul-09-2019=1***Jul-25-2019=1***Aug-11-2019=1***Sep-05-2019=1***Sep-09-2019=1***Sep-19-2019=1***Oct-02-2019=1***Oct-06-2019=1***Oct-14-2019=1***Oct-19-2019=1***Oct-20-2019=1***Oct-25-2019=1***Nov-01-2019=2***Nov-02-2019=2***Nov-04-2019=1***Nov-07-2019=1***Nov-19-2019=1***Dec-07-2019=1***Dec-16-2019=1***Jan-03-2020=1***Jan-08-2020=1***Jan-10-2020=2***Jan-26-2020=1***Mar-03-2020=1***Apr-08-2020=1***Apr-10-2020=1***May-19-2020=1***May-26-2020=1***Jun-08-2020=1***Jul-08-2020=1***Sep-07-2020=1***Oct-08-2020=1***Oct-10-2020=1***Nov-22-2020=1***Dec-17-2020=1***Jan-09-2021=1***Jan-17-2021=1***Jan-22-2021=1***Mar-26-2021=1***May-01-2021=1***May-03-2021=1***Aug-04-2021=1***Nov-20-2021=1***Feb-11-2022=1***Feb-21-2022=1***Apr-01-2022=1***May-28-2022=1***May-29-2022=1***Aug-30-2022=1***Mar-20-2023=1***Apr-29-2023=1***Sep-05-2023=1***Dec-17-2023=1***Feb-12-2024=1***Sep-30-2024=1***May-16-2026=2***May-17-2026=899***May-18-2026=143***May-19-2026=22***May-20-2026=5***May-21-2026=36***May-22-2026=27***May-23-2026=15***May-24-2026=2***May-25-2026=1***May-26-2026=2***May-27-2026=1***May-30-2026=1***May-31-2026=2***Jun-01-2026=1***Jun-02-2026=1***Jun-03-2026=2***Jun-04-2026=5***Jun-05-2026=1***Jun-06-2026=2***Jun-08-2026=1***Jun-10-2026=1***Jun-11-2026=3***Jun-14-2026=1***Jun-17-2026=1***Jun-18-2026=1***Jun-20-2026=1***Jun-21-2026=1***Jun-23-2026=2***Jun-26-2026=1***Jun-29-2026=1***Jul-02-2026=3***Jul-05-2026=1***Jul-06-2026=1***Jul-08-2026=1***Jul-09-2026=1***Jul-10-2026=458***Jul-11-2026=136***Jul-12-2026=2***Jul-13-2026=1' WHERE job_id= '283765'
|
| 0.0012 |
UPDATE employer_jobs SET monthly_hits = '***Mar-2019=260***Apr-2019=22***May-2019=8***Jun-2019=2***Jul-2019=4***Aug-2019=1***Sep-2019=3***Oct-2019=6***Nov-2019=7***Dec-2019=2***Jan-2020=5***Mar-2020=1***Apr-2020=2***May-2020=2***Jun-2020=1***Jul-2020=1***Sep-2020=1***Oct-2020=2***Nov-2020=1***Dec-2020=1***Jan-2021=3***Mar-2021=1***May-2021=2***Aug-2021=1***Nov-2021=1***Feb-2022=2***Apr-2022=1***May-2022=2***Aug-2022=1***Mar-2023=1***Apr-2023=1***Sep-2023=1***Dec-2023=1***Feb-2024=1***Sep-2024=1***May-2026=1156***Jun-2026=26***Jul-2026=604' WHERE job_id= '283765'
|
| 0.0024 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '283765' AND status LIKE 'sent%' ORDER BY id DESC
|
| 0.0009 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 283765
|
| 0.0013 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '272060' AND `date_added` >= '2022-06-08'
|
| 0.0009 |
select * from teasers
|
| 0.0008 |
SELECT * FROM skill_categories WHERE skill_cat_id='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='93' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='126' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='193' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='195' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='94' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='77' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='78' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='81' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='90' AND skill_cat_id ='12'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='222' AND skill_cat_id ='12'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='86' AND skill_cat_id ='12'
|
| 0.0008 |
SELECT * FROM skill_categories WHERE skill_cat_id='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='93' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='126' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='193' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='195' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='94' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='77' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='78' AND skill_cat_id ='1'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='81' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='90' AND skill_cat_id ='1'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='222' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='86' AND skill_cat_id ='1'
|
| 0.0008 |
SELECT * FROM skill_categories WHERE skill_cat_id='8'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='93' AND skill_cat_id ='8'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='126' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='193' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='195' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='94' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='8'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='8'
|
| 0.0007 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='77' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='78' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='81' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='90' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='222' AND skill_cat_id ='8'
|
| 0.0008 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='86' AND skill_cat_id ='8'
|