| 0.0003 |
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
|
| 0.0003 |
SELECT * FROM `employer_jobs` WHERE `job_id` = 784739 LIMIT 1
|
| 0.0037 |
SELECT * FROM `employers` WHERE `employer_id` = 11103 LIMIT 1
|
| 0.0236 |
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` = 784739 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 = '784739'
|
| 0.0008 |
SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 784739
|
| 0.0009 |
UPDATE employer_jobs SET hit_counts = '***Apr-27-2022=191***Apr-28-2022=19***Apr-29-2022=11***Apr-30-2022=3***May-01-2022=4***May-02-2022=3***May-03-2022=2***May-04-2022=1***May-05-2022=2***May-13-2022=1***May-25-2022=1***May-29-2022=1***Jun-11-2022=1***Aug-18-2022=1***Oct-30-2022=1***Nov-10-2022=1***Dec-06-2022=1***Dec-07-2022=2***Mar-20-2023=4***May-27-2023=2***Nov-07-2023=1***Nov-10-2023=2***Jul-30-2024=1***Nov-06-2024=1***Oct-20-2025=1***Oct-28-2025=1***Nov-07-2025=1***Nov-14-2025=1***Dec-17-2025=1***Jan-02-2026=1***Jan-10-2026=1***Apr-08-2026=2***Apr-13-2026=3***Apr-23-2026=291***Apr-24-2026=11***Apr-25-2026=7***Apr-26-2026=9***Apr-27-2026=5***Apr-28-2026=9***Apr-29-2026=3***Apr-30-2026=6***May-01-2026=5***May-02-2026=2***May-03-2026=6***May-04-2026=1***May-06-2026=7***May-09-2026=5***May-11-2026=1***May-13-2026=3***May-15-2026=2***May-16-2026=3***May-19-2026=1***May-22-2026=7***May-23-2026=3***May-24-2026=1***May-28-2026=1***May-30-2026=2***Jun-01-2026=10***Jun-02-2026=329***Jun-03-2026=4***Jun-04-2026=7***Jun-05-2026=6***Jun-06-2026=2***Jun-07-2026=2***Jun-08-2026=3***Jun-10-2026=3***Jun-12-2026=5***Jun-15-2026=1***Jun-16-2026=1***Jun-19-2026=5***Jun-20-2026=1***Jun-23-2026=1' WHERE job_id= '784739'
|
| 0.0007 |
UPDATE employer_jobs SET monthly_hits = '***Apr-2022=224***May-2022=15***Jun-2022=1***Aug-2022=1***Oct-2022=1***Nov-2022=1***Dec-2022=3***Mar-2023=4***May-2023=2***Nov-2023=3***Jul-2024=1***Nov-2024=1***Oct-2025=2***Nov-2025=2***Dec-2025=1***Jan-2026=2***Apr-2026=346***May-2026=50***Jun-2026=380' WHERE job_id= '784739'
|
| 0.0017 |
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '784739' 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` = 784739
|
| 0.0580 |
SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '11103' AND `date_added` >= '2022-06-08'
|
| 0.0003 |
select * from teasers
|
| 0.0003 |
SELECT * FROM skill_categories WHERE skill_cat_id='5'
|
| 0.0004 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='31' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='134' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='215' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_categories WHERE skill_cat_id='11'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='31' AND skill_cat_id ='11'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='134' AND skill_cat_id ='11'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='215' AND skill_cat_id ='11'
|
| 0.0001 |
SELECT * FROM skill_categories WHERE skill_cat_id='5'
|
| 0.0001 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='31' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='134' AND skill_cat_id ='5'
|
| 0.0002 |
SELECT * FROM skill_subcategories WHERE skill_sub_id='215' AND skill_cat_id ='5'
|