| 0.0008 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0003 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 219700 LIMIT 1
|
| 0.0004 |
SELECT * FROM `employers` WHERE `employer_id` = 186480 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` = 219700 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-10-17',ej.date_added) duration_days, DATEDIFF('2026-10-17',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-10-17',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '219700'
|
| 0.0003 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 219700
|
| 0.0007 |
UPDATE employer_jobs SET hit_counts = '***Jun-07-2018=20***Jun-08-2018=17***Jun-09-2018=7***Jun-10-2018=5***Jun-11-2018=8***Jun-12-2018=2***Jun-13-2018=3***Jun-14-2018=1***Jun-15-2018=1***Jun-19-2018=1***Jun-20-2018=1***Jun-24-2018=1***Jun-25-2018=1***Jun-30-2018=1***Jul-02-2018=1***Jul-03-2018=3***Jul-16-2018=1***Jul-21-2018=1***Jul-23-2018=1***Jul-25-2018=1***Aug-01-2018=2***Aug-15-2018=1***Aug-28-2018=1***Sep-07-2018=1***Dec-27-2018=1***Dec-30-2018=1***Jan-20-2019=1***Feb-15-2019=1***Feb-18-2019=1***Feb-22-2019=1***Feb-24-2019=1***Mar-23-2019=1***Apr-01-2019=1***Apr-03-2019=1***Apr-17-2019=2***Apr-18-2019=1***May-11-2019=1***Jun-22-2019=1***Aug-03-2019=1***Sep-27-2019=1***Oct-29-2019=1***Nov-17-2019=2***Nov-28-2019=1***Dec-12-2019=1***Dec-20-2019=1***Jan-15-2020=1***Jan-18-2020=1***Apr-19-2020=1***Jul-28-2020=1***Oct-27-2020=1***Feb-01-2021=1***May-09-2021=1***Aug-26-2021=1***Nov-25-2021=1***Feb-24-2022=1***Jun-09-2022=1***Sep-22-2022=1***Sep-24-2022=1***Jul-07-2023=1***Jul-08-2024=1***Jul-15-2024=1***Sep-29-2026=2***Oct-01-2026=614***Oct-02-2026=77***Oct-03-2026=15***Oct-04-2026=9***Oct-05-2026=7***Oct-06-2026=5***Oct-07-2026=47***Oct-08-2026=264***Oct-09-2026=52***Oct-10-2026=7***Oct-12-2026=2***Oct-15-2026=1***Oct-17-2026=3' WHERE job_id= '219700'
|
| 0.0006 |
UPDATE employer_jobs SET monthly_hits = '***Jun-2018=69***Jul-2018=8***Aug-2018=4***Sep-2018=1***Dec-2018=2***Jan-2019=1***Feb-2019=4***Mar-2019=1***Apr-2019=5***May-2019=1***Jun-2019=1***Aug-2019=1***Sep-2019=1***Oct-2019=1***Nov-2019=3***Dec-2019=2***Jan-2020=2***Apr-2020=1***Jul-2020=1***Oct-2020=1***Feb-2021=1***May-2021=1***Aug-2021=1***Nov-2021=1***Feb-2022=1***Jun-2022=1***Sep-2022=2***Jul-2023=1***Jul-2024=2***Sep-2026=2***Oct-2026=1103' WHERE job_id= '219700'
|
| 0.0015 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '219700' 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` = 219700
|
| 0.0062 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '186480' AND `date_added` >= '2022-06-08'
|
| 0.0003 |
select * from teasers
|
| 0.0017 |
SELECT * FROM skill_categories WHERE skill_cat_id='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='128' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='194' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='72' AND skill_cat_id ='12'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='137' AND skill_cat_id ='12'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='201' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='122' AND skill_cat_id ='12'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='222' AND skill_cat_id ='12'
|
| 0.0001 |
SELECT * FROM skill_categories WHERE skill_cat_id='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='128' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='194' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='72' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='137' AND skill_cat_id ='1'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='201' AND skill_cat_id ='1'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='122' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='222' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_categories WHERE skill_cat_id='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='128' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='194' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='72' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='137' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='201' AND skill_cat_id ='3'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='122' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='222' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_categories WHERE skill_cat_id='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='128' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='194' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='72' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='137' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='201' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='122' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='222' AND skill_cat_id ='8'
|