| 0.0004 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0004 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 189052 LIMIT 1
|
| 0.0004 |
SELECT * FROM `employers` WHERE `employer_id` = 8389 LIMIT 1
|
| 0.0544 |
SELECT COUNT(DISTINCT t.id) as cnt FROM `t_thread` `t` INNER JOIN `t_message` `m` ON `t`.`id` = `m`.`thread_id` INNER JOIN `t_message_employer` `e` ON `m`.`id` = `e`.`message_id` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 189052 AND `misc`.`id` IS NULL
|
| 0.0006 |
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-06-23',ej.date_added) duration_days, DATEDIFF('2026-06-23',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-06-23',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '189052'
|
| 0.0008 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 189052
|
| 0.0007 |
UPDATE employer_jobs SET hit_counts = '***Jan-11-2018=130***Jan-12-2018=36***Jan-13-2018=15***Jan-14-2018=19***Jan-15-2018=11***Jan-16-2018=11***Jan-17-2018=10***Jan-18-2018=14***Jan-19-2018=12***Jan-20-2018=6***Jan-21-2018=7***Jan-22-2018=4***Jan-23-2018=2***Jan-24-2018=5***Jan-25-2018=3***Jan-26-2018=5***Jan-27-2018=1***Jan-28-2018=2***Jan-29-2018=8***Jan-30-2018=2***Jan-31-2018=3***Feb-01-2018=3***Feb-02-2018=3***Feb-03-2018=2***Feb-04-2018=3***Feb-05-2018=5***Feb-06-2018=4***Feb-07-2018=3***Feb-08-2018=3***Feb-09-2018=1***Feb-10-2018=3***Feb-11-2018=4***Feb-12-2018=1***Feb-13-2018=1***Feb-15-2018=2***Feb-16-2018=2***Feb-17-2018=2***Feb-18-2018=2***Feb-19-2018=1***Feb-20-2018=2***Feb-21-2018=3***Feb-22-2018=2***Feb-23-2018=1***Feb-24-2018=2***Feb-25-2018=1***Feb-26-2018=3***Feb-27-2018=1***Feb-28-2018=2***Mar-01-2018=3***Mar-02-2018=3***Mar-03-2018=2***Mar-04-2018=3***Mar-05-2018=2***Mar-06-2018=2***Mar-07-2018=2***Mar-08-2018=3***Mar-09-2018=3***Mar-10-2018=2***Mar-11-2018=1***Mar-12-2018=2***Mar-13-2018=2***Mar-14-2018=2***Mar-15-2018=1***Mar-16-2018=1***Mar-17-2018=1***Mar-18-2018=1***Mar-19-2018=2***Mar-20-2018=2***Mar-21-2018=2***Apr-12-2018=1***Apr-22-2018=1***May-28-2018=1***Jul-08-2018=1***Jul-18-2018=1***Jul-19-2018=1***Aug-05-2018=1***Sep-07-2018=1***Sep-21-2018=1***Oct-03-2018=2***Nov-22-2018=1***Feb-17-2019=1***Apr-01-2019=1***Apr-02-2019=1***Apr-15-2019=1***Apr-17-2019=1***Apr-18-2019=1***May-11-2019=1***Jul-06-2019=1***Jul-11-2019=1***Jul-20-2019=1***Jul-30-2019=1***Aug-10-2019=1***Aug-20-2019=1***Sep-14-2019=1***Sep-30-2019=1***Oct-19-2019=1***Nov-07-2019=1***Nov-13-2019=1***Nov-30-2019=1***Dec-19-2019=1***Jan-04-2020=1***Jan-06-2020=2***Jan-08-2020=1***Jan-09-2020=1***Jan-11-2020=1***Jan-30-2020=1***Feb-12-2020=1***Feb-27-2020=1***Feb-29-2020=1***Mar-27-2020=1***May-04-2020=1***May-20-2020=1***May-24-2020=1***Jun-09-2020=1***Jul-15-2020=1***Nov-28-2020=1***Dec-24-2020=1***Mar-13-2022=1***Aug-16-2023=1***Sep-09-2023=1***Dec-14-2023=1***Aug-21-2025=2***Oct-25-2025=1***Oct-27-2025=1***Oct-28-2025=2***Oct-29-2025=1***Nov-08-2025=1***Feb-15-2026=1***Feb-19-2026=1***Mar-12-2026=1***Apr-22-2026=1***Apr-28-2026=1***May-13-2026=705***May-14-2026=68***May-15-2026=43***May-16-2026=21***May-17-2026=14***May-18-2026=21***May-19-2026=21***May-20-2026=28***May-21-2026=13***May-22-2026=13***May-23-2026=10***May-24-2026=1***May-25-2026=6***May-26-2026=7***May-27-2026=10***May-28-2026=8***May-29-2026=6***May-30-2026=3***May-31-2026=5***Jun-01-2026=65***Jun-02-2026=15***Jun-03-2026=4***Jun-04-2026=12***Jun-05-2026=4***Jun-06-2026=3***Jun-07-2026=4***Jun-08-2026=3***Jun-09-2026=2***Jun-10-2026=2***Jun-11-2026=1***Jun-12-2026=2***Jun-14-2026=3***Jun-15-2026=1***Jun-16-2026=1***Jun-18-2026=1***Jun-19-2026=4***Jun-20-2026=4***Jun-23-2026=2' WHERE job_id= '189052'
|
| 0.0014 |
UPDATE employer_jobs SET monthly_hits = '***Jan-2018=306***Feb-2018=62***Mar-2018=42***Apr-2018=2***May-2018=1***Jul-2018=3***Aug-2018=1***Sep-2018=2***Oct-2018=2***Nov-2018=1***Feb-2019=1***Apr-2019=5***May-2019=1***Jul-2019=4***Aug-2019=2***Sep-2019=2***Oct-2019=1***Nov-2019=3***Dec-2019=1***Jan-2020=7***Feb-2020=3***Mar-2020=1***May-2020=3***Jun-2020=1***Jul-2020=1***Nov-2020=1***Dec-2020=1***Mar-2022=1***Aug-2023=1***Sep-2023=1***Dec-2023=1***Aug-2025=2***Oct-2025=5***Nov-2025=1***Feb-2026=2***Mar-2026=1***Apr-2026=2***May-2026=1002***Jun-2026=133' WHERE job_id= '189052'
|
| 0.0034 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '189052' 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` = 189052
|
| 0.0144 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '8389' AND `date_added` >= '2022-06-08'
|
| 0.0003 |
select * from teasers
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='12'
|
| 0.0011 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='12'
|
| 0.0003 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='192' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='126' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='193' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='124' 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='223' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='163' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='172' AND skill_cat_id ='12'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='173' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='82' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='171' AND skill_cat_id ='12'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='192' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='126' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='193' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='124' 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='223' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='163' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='172' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='173' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='82' AND skill_cat_id ='1'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='171' AND skill_cat_id ='1'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='192' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='126' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='193' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='124' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='223' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='163' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='172' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='173' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='82' AND skill_cat_id ='8'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='171' AND skill_cat_id ='8'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='192' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='126' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='193' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='124' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='223' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='163' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='172' AND skill_cat_id ='9'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='173' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='82' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='171' AND skill_cat_id ='9'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='125' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='192' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='126' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='193' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='124' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='2' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='1' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='223' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='95' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='163' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='172' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='173' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='82' AND skill_cat_id ='17'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='171' AND skill_cat_id ='17'
|