1: -- CACHE: 10m SELECT j.id, j.title, j.empl AS `company`, j.deadline_date AS `deadline`, jv.views AS `hits`, jc.company_id FROM v2_jobs j LEFT JOIN v2_job_views jv on j.id = jv.job_id LEFT JOIN v2_job_company jc on j.id = jc.job_id WHERE j.active = 1 AND j.verified = 1 AND j.expired = 0 AND j.member_job = 0 ORDER BY j.posted_date DESC LIMIT 5

-- 1 ms; returned 5 row(s)

2: SELECT jl.location_id FROM v2_job_locations jl WHERE jl.job_id = 60895

-- 0 ms; returned ('22')

3: SELECT name FROM v2_regions WHERE -id IN ('22') UNION SELECT name FROM v2_countries WHERE id IN ('22')

-- 0 ms; returned ('Algeria')

4: SELECT jl.location_id FROM v2_job_locations jl WHERE jl.job_id = 60894

-- 0 ms; returned ('26')

5: SELECT name FROM v2_regions WHERE -id IN ('26') UNION SELECT name FROM v2_countries WHERE id IN ('26')

-- 0 ms; returned ('Benin')

6: SELECT jl.location_id FROM v2_job_locations jl WHERE jl.job_id = 60893

-- 0 ms; returned 5 row(s)

7: SELECT name FROM v2_regions WHERE -id IN ('42', '88', '173', '177', '208') UNION SELECT name FROM v2_countries WHERE id IN ('42', '88', '173', '177', '208')

-- 0 ms; returned 5 row(s)

8: SELECT jl.location_id FROM v2_job_locations jl WHERE jl.job_id = 60892

-- 0 ms; returned ('22')

9: SELECT name FROM v2_regions WHERE -id IN ('22') UNION SELECT name FROM v2_countries WHERE id IN ('22')

-- 0 ms; returned ('Algeria')

10: SELECT jl.location_id FROM v2_job_locations jl WHERE jl.job_id = 60888

-- 0 ms; returned ('24')

11: SELECT name FROM v2_regions WHERE -id IN ('24') UNION SELECT name FROM v2_countries WHERE id IN ('24')

-- 0 ms; returned ('Afghanistan')

12: -- CACHE: 10m SELECT COUNT(*) FROM v2_jobs WHERE active=1 AND expired=0 AND deadline_date >DATE_SUB(NOW(), INTERVAL 1 DAY)

-- 3 ms; returned ('319')

13: -- CACHE: 30m SELECT DISTINCT(e.id), COUNT(en.country_id) AS 'nationalities', ei.first_name, ei.last_name, c.name AS `country`, ei.work_experience_since,ei.description, dt.name AS 'degree' FROM v2_experts e LEFT JOIN v2_membersList m ON m.user_id = e.id LEFT JOIN v2_expert_info ei ON e.id = ei.expert_id LEFT JOIN v2_degree_types dt ON ei.highest_degree=dt.id LEFT JOIN v2_expert_nationality en ON en.expert_id=e.id LEFT JOIN v2_countries c ON c.id = en.country_id WHERE m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0 GROUP BY e.id ORDER BY RAND() LIMIT 3

-- 1 ms; returned 3 row(s)

14: -- CACHE: 30m SELECT COUNT(*) FROM v2_membersList m WHERE m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

-- 0 ms; returned ('6')

15: -- CACHE: 10m SELECT t.id, t.name , d.name AS `donor`, tast.name as `status`, c.name as `location` FROM v2_tenders t INNER JOIN v2_tender_donors td ON t.id = td.tender_id INNER JOIN v2_donors d ON d.id = td.donor_id LEFT JOIN v2_tender_status tst ON t.id = tst.tender_id LEFT JOIN v2_tender_all_statuses tast ON tst.status_id = tast.id LEFT JOIN v2_tender_locations tl ON tl.tender_id=t.id LEFT JOIN v2_countries c ON tl.country_id=c.id WHERE t.active = 1 AND t.verified = 1 GROUP BY t.id ORDER BY t.last_modified_date DESC LIMIT 4

-- 576 ms; returned 4 row(s)

16: -- CACHE: 30m SELECT COUNT(*) FROM v2_membersList m WHERE m.user_type = 1 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

-- 1 ms; returned ('6')

17: -- CACHE: 30m SELECT DISTINCT(c.id),cd.name,cd.description FROM v2_companies c LEFT JOIN v2_company_description cd ON cd.company_id = c.id LEFT JOIN v2_membersList m ON m.user_id = c.id WHERE m.user_type = 1 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0 ORDER BY RAND() LIMIT 4

-- 1 ms; returned 4 row(s)

18: -- CACHE: 10m SELECT COUNT(*) FROM v2_tenders WHERE active=1 AND verified=1

-- 6 ms; returned ('16710')

19: -- CACHE: 30m SELECT COUNT(*) FROM `v2_broadcast_cv` WHERE `done` = 1

-- 64 ms; returned ('233')

20: SELECT COUNT(*) FROM `v2_experts` WHERE active = 1 AND suspended = 0

-- 0 ms; returned ('9169')

21: SELECT COUNT(*) FROM `v2_companies` WHERE active = 1 AND suspended = 0

-- 0 ms; returned ('10')