| 0.0004 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0003 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 955790 LIMIT 1
|
| 0.0004 |
SELECT * FROM `employers` WHERE `employer_id` = 405911 LIMIT 1
|
| 0.0024 |
SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 955790 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-17',ej.date_added) duration_days, DATEDIFF('2026-04-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-04-17',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '955790'
|
| 0.0003 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 955790
|
| 0.0010 |
UPDATE employer_jobs SET hit_counts = '***Apr-04-2023=85***Apr-05-2023=10***Apr-06-2023=4***Apr-07-2023=2***Apr-08-2023=1***Apr-09-2023=1***Apr-12-2023=1***Apr-13-2023=1***Apr-15-2023=1***Apr-22-2023=1***Apr-27-2023=1***Apr-28-2023=1***May-04-2023=3***May-05-2023=4***May-07-2023=1***May-09-2023=1***May-14-2023=152***May-15-2023=23***May-16-2023=6***May-17-2023=2***May-18-2023=3***May-19-2023=1***May-22-2023=2***May-24-2023=2***May-25-2023=1***May-26-2023=1***May-27-2023=1***Jun-05-2023=1***Jun-06-2023=1***Jun-08-2023=1***Jun-10-2023=4***Jun-11-2023=1***Jun-23-2023=1***Jun-24-2023=3***Jun-26-2023=3***Jun-29-2023=1***Jul-10-2023=1***Jul-12-2023=1***Jul-19-2023=1***Jul-20-2023=1***Jul-21-2023=1***Jul-22-2023=1***Jul-23-2023=1***Jul-25-2023=1***Jul-26-2023=2***Jul-28-2023=1***Jul-29-2023=1***Jul-30-2023=2***Jul-31-2023=1***Aug-01-2023=4***Aug-02-2023=1***Aug-03-2023=1***Aug-04-2023=1***Aug-06-2023=1***Aug-18-2023=1***Aug-28-2023=1***Aug-29-2023=1***Aug-30-2023=1***Sep-05-2023=2***Sep-07-2023=1***Sep-15-2023=1***Sep-16-2023=2***Sep-17-2023=1***Sep-19-2023=1***Sep-24-2023=1***Sep-26-2023=1***Oct-06-2023=1***Oct-07-2023=1***Oct-28-2023=1***Nov-07-2023=1***Nov-08-2023=1***Dec-05-2023=1***Dec-09-2023=1***Mar-09-2024=15***Mar-10-2024=3***Mar-12-2024=123***Mar-13-2024=20***Mar-14-2024=6***Mar-15-2024=7***Mar-16-2024=4***Mar-17-2024=1***Mar-20-2024=2***Mar-22-2024=1***Mar-25-2024=3***Mar-30-2024=1***Mar-31-2024=1***Apr-01-2024=1***Apr-07-2024=2***Apr-11-2024=1***Apr-13-2024=1***Apr-15-2024=1***Apr-27-2024=1***May-04-2024=1***May-11-2024=1***May-14-2024=1***May-30-2024=2***May-31-2024=2***Jun-04-2024=2***Jun-21-2024=2***Jul-20-2024=1***Oct-06-2024=1***Oct-20-2024=1***Nov-16-2024=2***Dec-22-2024=1***Feb-06-2025=1***Mar-12-2025=2***Mar-26-2025=1***Apr-23-2025=1***May-19-2025=1***Jun-15-2025=1***Jun-30-2025=2***Jul-22-2025=1***Dec-10-2025=1***Jan-03-2026=1***Feb-04-2026=1***Feb-15-2026=1***Feb-16-2026=1***Feb-17-2026=1***Feb-18-2026=1***Feb-19-2026=1***Feb-20-2026=1***Mar-08-2026=1***Mar-10-2026=1***Mar-12-2026=1***Mar-14-2026=1***Mar-15-2026=1***Mar-16-2026=93***Mar-17-2026=123***Mar-18-2026=17***Mar-19-2026=11***Mar-20-2026=4***Mar-21-2026=1***Mar-22-2026=1***Mar-23-2026=12***Mar-24-2026=6***Mar-25-2026=11***Mar-26-2026=7***Mar-27-2026=6***Mar-28-2026=2***Mar-30-2026=5***Mar-31-2026=6***Apr-01-2026=5***Apr-02-2026=5***Apr-03-2026=16***Apr-04-2026=1***Apr-06-2026=2***Apr-07-2026=3***Apr-08-2026=2***Apr-09-2026=2***Apr-10-2026=2***Apr-17-2026=1' WHERE job_id= '955790'
|
| 0.0006 |
UPDATE employer_jobs SET monthly_hits = '***Apr-2023=109***May-2023=203***Jun-2023=16***Jul-2023=15***Aug-2023=12***Sep-2023=10***Oct-2023=3***Nov-2023=2***Dec-2023=2***Mar-2024=187***Apr-2024=7***May-2024=7***Jun-2024=4***Jul-2024=1***Oct-2024=2***Nov-2024=2***Dec-2024=1***Feb-2025=1***Mar-2025=3***Apr-2025=1***May-2025=1***Jun-2025=3***Jul-2025=1***Dec-2025=1***Jan-2026=1***Feb-2026=7***Mar-2026=309***Apr-2026=39' WHERE job_id= '955790'
|
| 0.0019 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '955790' 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` = 955790
|
| 0.0080 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '405911' AND `date_added` >= '2022-06-08'
|
| 0.0004 |
select * from teasers
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='122' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='1'
|
| 0.0002 |
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.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='203' AND skill_cat_id ='3'
|
| 0.0001 |
SELECT * FROM skill_categories WHERE skill_cat_id='14'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='14'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='122' AND skill_cat_id ='14'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='203' AND skill_cat_id ='14'
|