| 0.0029 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0030 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 854587 LIMIT 1
|
| 0.0111 |
SELECT * FROM `employers` WHERE `employer_id` = 422311 LIMIT 1
|
| 0.0038 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 854587 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-07-30',ej.date_added) duration_days, DATEDIFF('2026-07-30',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-30',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '854587'
|
| 0.0011 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 854587
|
| 0.0007 |
UPDATE employer_jobs SET hit_counts = '***Aug-16-2022=121***Aug-17-2022=104***Aug-18-2022=39***Aug-19-2022=22***Aug-20-2022=9***Aug-21-2022=9***Aug-22-2022=9***Aug-23-2022=9***Aug-24-2022=10***Aug-25-2022=4***Aug-26-2022=103***Aug-27-2022=191***Aug-28-2022=63***Aug-29-2022=56***Aug-30-2022=27***Aug-31-2022=34***Sep-01-2022=9***Sep-02-2022=4***Sep-03-2022=9***Sep-04-2022=4***Sep-05-2022=3***Sep-06-2022=10***Sep-07-2022=4***Sep-08-2022=3***Sep-09-2022=6***Sep-10-2022=6***Sep-11-2022=5***Sep-12-2022=2***Sep-13-2022=3***Sep-14-2022=3***Sep-15-2022=2***Sep-16-2022=2***Sep-17-2022=1***Sep-18-2022=4***Sep-19-2022=4***Sep-20-2022=4***Sep-21-2022=1***Sep-22-2022=2***Sep-23-2022=1***Sep-24-2022=162***Sep-25-2022=109***Sep-26-2022=47***Sep-27-2022=17***Sep-28-2022=10***Sep-29-2022=3***Sep-30-2022=14***Oct-01-2022=6***Oct-02-2022=7***Oct-03-2022=5***Oct-04-2022=3***Oct-05-2022=8***Oct-06-2022=2***Oct-07-2022=8***Oct-08-2022=6***Oct-09-2022=2***Oct-10-2022=1***Oct-11-2022=1***Oct-17-2022=1***Oct-21-2022=1***Oct-22-2022=1***Oct-24-2022=1***Oct-25-2022=1***Oct-26-2022=1***Nov-09-2022=1***Nov-17-2022=1***Nov-24-2022=1***Nov-29-2022=1***Dec-04-2022=1***Dec-13-2022=1***Jan-23-2023=1***Mar-08-2023=2***Sep-07-2023=1***Sep-26-2023=1***Oct-28-2023=1***Aug-13-2024=1***Apr-06-2026=1***Apr-16-2026=1***Apr-17-2026=1***Jun-13-2026=1***Jul-09-2026=386***Jul-10-2026=37***Jul-11-2026=17***Jul-12-2026=10***Jul-13-2026=16***Jul-14-2026=12***Jul-15-2026=11***Jul-16-2026=13***Jul-17-2026=8***Jul-18-2026=2***Jul-19-2026=1***Jul-20-2026=2***Jul-21-2026=6***Jul-22-2026=5***Jul-23-2026=4***Jul-24-2026=258***Jul-25-2026=170***Jul-26-2026=8***Jul-30-2026=1' WHERE job_id= '854587'
|
| 0.0006 |
UPDATE employer_jobs SET monthly_hits = '***Aug-2022=810***Sep-2022=454***Oct-2022=55***Nov-2022=4***Dec-2022=2***Jan-2023=1***Mar-2023=2***Sep-2023=2***Oct-2023=1***Aug-2024=1***Apr-2026=3***Jun-2026=1***Jul-2026=965' WHERE job_id= '854587'
|
| 0.0021 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '854587' AND status LIKE 'sent%' ORDER BY id DESC
|
| 0.0004 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 854587
|
| 0.0024 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '422311' AND `date_added` >= '2022-06-08'
|
| 0.0004 |
select * from teasers
|
| 0.0004 |
SELECT * FROM skill_categories WHERE skill_cat_id='1'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='1'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='1'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='140' AND skill_cat_id ='1'
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='1'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='1'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='1'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='140' AND skill_cat_id ='1'
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='3'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='3'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='3'
|
| 0.0004 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='140' AND skill_cat_id ='3'
|