| 0.0003 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0004 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 308683 LIMIT 1
|
| 0.0013 |
SELECT * FROM `employers` WHERE `employer_id` = 215959 LIMIT 1
|
| 0.0753 |
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` = 308683 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 = '308683'
|
| 0.0012 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 308683
|
| 0.0014 |
UPDATE employer_jobs SET hit_counts = '***Jun-18-2019=21***Jun-19-2019=50***Jun-20-2019=18***Jun-21-2019=13***Jun-22-2019=13***Jun-23-2019=6***Jun-24-2019=6***Jun-25-2019=2***Jun-26-2019=2***Jun-27-2019=7***Jun-28-2019=1***Jun-29-2019=1***Jun-30-2019=1***Jul-05-2019=2***Jul-06-2019=1***Jul-07-2019=2***Jul-08-2019=3***Jul-13-2019=1***Jul-14-2019=1***Jul-15-2019=2***Jul-17-2019=1***Jul-18-2019=2***Jul-19-2019=1***Jul-21-2019=5***Jul-22-2019=1***Jul-23-2019=2***Jul-24-2019=1***Jul-25-2019=2***Aug-04-2019=1***Aug-06-2019=1***Aug-08-2019=2***Aug-09-2019=1***Aug-11-2019=1***Aug-17-2019=1***Aug-25-2019=1***Sep-15-2019=1***Sep-30-2019=1***Oct-01-2019=1***Oct-05-2019=1***Oct-20-2019=1***Nov-10-2019=1***Dec-01-2019=1***Dec-14-2019=1***Jan-09-2020=1***Jan-11-2020=1***Jan-16-2020=1***Jan-29-2020=1***Mar-08-2020=1***Mar-28-2020=1***Apr-12-2020=1***Apr-16-2020=1***May-05-2020=1***May-25-2020=1***Jun-14-2020=1***Jul-15-2020=1***Jul-16-2020=2***Oct-17-2020=1***Nov-28-2020=1***Jan-17-2021=1***Apr-18-2021=1***Jul-18-2021=1***Oct-20-2021=1***Dec-08-2021=1***Jan-24-2022=1***Mar-28-2022=1***May-25-2022=1***Aug-31-2022=1***Sep-05-2023=1***Nov-17-2023=1***Dec-06-2023=1***Dec-07-2023=2***Jan-10-2024=1***Mar-20-2024=1***Apr-25-2024=1***Nov-04-2024=1***Jul-06-2025=1***Oct-18-2025=1***Oct-25-2025=1***Jan-27-2026=1***Feb-12-2026=253***Feb-13-2026=45***Feb-14-2026=10***Feb-15-2026=7***Feb-16-2026=8***Feb-17-2026=8***Feb-18-2026=6***Feb-19-2026=8***Feb-20-2026=7***Feb-21-2026=3***Feb-22-2026=1***Feb-23-2026=3***Feb-25-2026=6***Feb-26-2026=1***Feb-27-2026=6***Feb-28-2026=3***Mar-01-2026=2***Mar-02-2026=8***Mar-03-2026=1***Mar-04-2026=4***Mar-05-2026=2***Mar-06-2026=11***Mar-07-2026=1***Mar-08-2026=3***Mar-10-2026=2***Mar-11-2026=4***Mar-12-2026=4***Mar-13-2026=6***Mar-14-2026=4***Mar-15-2026=1***Mar-16-2026=2***Mar-17-2026=1***Mar-18-2026=3***Mar-19-2026=2***Mar-20-2026=2***Mar-21-2026=1***Mar-22-2026=1***Mar-23-2026=7***Mar-24-2026=1***Mar-25-2026=3***Mar-27-2026=3***Mar-28-2026=1***Mar-31-2026=2***Apr-02-2026=1***Apr-03-2026=1***Apr-04-2026=1***Apr-05-2026=3***Apr-06-2026=2***Apr-07-2026=2***Apr-08-2026=2***Apr-11-2026=1***Apr-13-2026=1***Apr-15-2026=1***Apr-18-2026=1***Apr-19-2026=1***Apr-20-2026=1***Apr-22-2026=3***Apr-24-2026=2***Apr-26-2026=1***Apr-28-2026=2***Apr-30-2026=1***May-04-2026=2***May-08-2026=1***May-09-2026=2***May-11-2026=2***May-20-2026=1***May-21-2026=1***May-25-2026=1***May-26-2026=1***May-30-2026=2***Jun-01-2026=18***Jun-02-2026=3***Jun-09-2026=1***Jun-10-2026=1***Jun-23-2026=1' WHERE job_id= '308683'
|
| 0.0006 |
UPDATE employer_jobs SET monthly_hits = '***Jun-2019=141***Jul-2019=27***Aug-2019=8***Sep-2019=2***Oct-2019=3***Nov-2019=1***Dec-2019=2***Jan-2020=4***Mar-2020=2***Apr-2020=2***May-2020=2***Jun-2020=1***Jul-2020=3***Oct-2020=1***Nov-2020=1***Jan-2021=1***Apr-2021=1***Jul-2021=1***Oct-2021=1***Dec-2021=1***Jan-2022=1***Mar-2022=1***May-2022=1***Aug-2022=1***Sep-2023=1***Nov-2023=1***Dec-2023=3***Jan-2024=1***Mar-2024=1***Apr-2024=1***Nov-2024=1***Jul-2025=1***Oct-2025=2***Jan-2026=1***Feb-2026=375***Mar-2026=82***Apr-2026=27***May-2026=13***Jun-2026=24' WHERE job_id= '308683'
|
| 0.0026 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '308683' 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` = 308683
|
| 0.0216 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '215959' AND `date_added` >= '2022-06-08'
|
| 0.0004 |
select * from teasers
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='4'
|
| 0.0010 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='4'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='15'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='154' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='150' AND skill_cat_id ='14'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='143' AND skill_cat_id ='14'
|