| 0.0003 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0003 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 731434 LIMIT 1
|
| 0.0003 |
SELECT * FROM `employers` WHERE `employer_id` = 501258 LIMIT 1
|
| 0.0025 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 731434 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-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 = '731434'
|
| 0.0011 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 731434
|
| 0.0007 |
UPDATE employer_jobs SET hit_counts = '***Feb-16-2022=96***Feb-17-2022=7***Feb-18-2022=7***Feb-19-2022=4***Feb-20-2022=1***Feb-21-2022=2***Feb-22-2022=3***Feb-23-2022=2***Feb-24-2022=2***Feb-25-2022=1***Feb-26-2022=3***Feb-27-2022=3***Feb-28-2022=1***Mar-01-2022=1***Mar-03-2022=3***Mar-07-2022=1***Mar-08-2022=1***Mar-13-2022=1***Mar-14-2022=3***Mar-15-2022=3***Mar-16-2022=1***Mar-22-2022=1***Apr-04-2022=1***Jun-11-2022=1***Jun-14-2022=1***Sep-14-2022=1***Jan-04-2023=1***Jan-09-2023=1***Apr-13-2023=1***Jun-26-2023=1***Aug-31-2023=1***Dec-12-2023=1***Jan-04-2024=1***Feb-01-2024=1***Feb-14-2024=1***Feb-29-2024=1***Mar-06-2024=1***Mar-27-2024=1***Apr-02-2024=1***Apr-09-2024=1***Apr-24-2024=1***Apr-29-2024=1***May-03-2024=1***May-08-2024=1***May-13-2024=1***May-22-2024=1***May-24-2024=1***May-29-2024=1***Jun-09-2024=1***Jun-17-2024=1***Jun-26-2024=1***Nov-06-2024=1***Jul-03-2025=1***Sep-11-2025=1***Sep-13-2025=1***Nov-18-2025=1***Dec-24-2025=1***Jan-14-2026=1***Jan-21-2026=1***Mar-22-2026=1***Apr-29-2026=1***Jul-26-2026=770***Jul-29-2026=1***Jul-30-2026=2' WHERE job_id= '731434'
|
| 0.0009 |
UPDATE employer_jobs SET monthly_hits = '***Feb-2022=132***Mar-2022=15***Apr-2022=1***Jun-2022=2***Sep-2022=1***Jan-2023=2***Apr-2023=1***Jun-2023=1***Aug-2023=1***Dec-2023=1***Jan-2024=1***Feb-2024=3***Mar-2024=2***Apr-2024=4***May-2024=6***Jun-2024=3***Nov-2024=1***Jul-2025=1***Sep-2025=2***Nov-2025=1***Dec-2025=1***Jan-2026=2***Mar-2026=1***Apr-2026=1***Jul-2026=773' WHERE job_id= '731434'
|
| 0.0020 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '731434' 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` = 731434
|
| 0.0043 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '501258' AND `date_added` >= '2022-06-08'
|
| 0.0004 |
select * from teasers
|
| 0.0032 |
SELECT * FROM skill_categories WHERE skill_cat_id='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='69' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='205' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='69' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='205' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='69' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='205' AND skill_cat_id ='14'
|