1: SELECT COUNT(e.id) FROM v2_experts e

-- 0 ms; returned ('9169')

2: SELECT COUNT(n.id) FROM v2_newsletter n

-- 0 ms; returned ('2845')

3: SELECT COUNT(c.id) FROM v2_companies c

-- 0 ms; returned ('10')

4: SELECT COUNT(c.id) FROM v2_companies c

-- 0 ms; returned ('10')

5: SELECT COUNT(c.id) FROM v2_bcv_extra_companies c

-- 0 ms; returned ('991')

6: SELECT COUNT(j.id) FROM v2_jobs j WHERE j.expired = 0

-- 0 ms; returned ('433')

7: SELECT id AS ARRAY_KEY, name FROM v2_regions WHERE 1=1 AND active = 1 ORDER BY name ASC

-- 0 ms; returned 6 row(s)

8: -- CACHE: 10m SELECT id AS ARRAY_KEY, name FROM v2_countries WHERE 1=1 AND active = 1 ORDER BY name ASC

-- 1 ms; returned 246 row(s)

9: SELECT id AS ARRAY_KEY, name FROM v2_sectors WHERE 1=1 AND active = 1 AND level = 0 ORDER BY name ASC

-- 1 ms; returned 79 row(s)

10: SELECT id as ARRAY_KEY, name FROM v2_opportunity_types

-- 19 ms; returned 5 row(s)

11: -- 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 6

-- 2 ms; returned 5 row(s)

12: -- 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

-- 1 ms; returned ('6')

13: SELECT DISTINCT(j.id),DBSIMPLE_ERROR_NO_VALUE FROM v2_jobs j LEFT JOIN v2_job_company jc ON j.id = jc.job_id LEFT JOIN v2_job_views jv ON j.id = jv.job_id LEFT JOIN v2_job_locations jl ON j.id = jl.job_id LEFT JOIN v2_job_sectors js ON j.id = js.job_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_job_langs jln ON j.id = jln.job_id WHERE 1=1 AND j.id IN (DBSIMPLE_ERROR_NO_VALUE) AND js.sector_id = DBSIMPLE_ERROR_NO_VALUE AND js.sector_id IN (DBSIMPLE_ERROR_NO_VALUE) AND jln.lang_id = DBSIMPLE_ERROR_NO_VALUE AND jln.lang_id IN (DBSIMPLE_ERROR_NO_VALUE) AND j.empl_type_id = DBSIMPLE_ERROR_NO_VALUE AND j.empl_type_id IN (DBSIMPLE_ERROR_NO_VALUE) AND jl.location_id IN (DBSIMPLE_ERROR_NO_VALUE) AND j.min_exp >= DBSIMPLE_ERROR_NO_VALUE AND j.max_exp <= DBSIMPLE_ERROR_NO_VALUE AND j.max_exp != 0 AND (j.max_exp = DBSIMPLE_ERROR_NO_VALUE OR j.max_exp >= DBSIMPLE_ERROR_NO_VALUE) AND j.opp_type_id = DBSIMPLE_ERROR_NO_VALUE AND j.opp_type_id IN (DBSIMPLE_ERROR_NO_VALUE) AND j.posted_date <= NOW() AND j.posted_date >= ( NOW() - INTERVAL DBSIMPLE_ERROR_NO_VALUE HOUR ) AND j.posted_date > DBSIMPLE_ERROR_NO_VALUE AND j.active = DBSIMPLE_ERROR_NO_VALUE AND j.verified = DBSIMPLE_ERROR_NO_VALUE AND j.member_job = DBSIMPLE_ERROR_NO_VALUE AND j.expired = DBSIMPLE_ERROR_NO_VALUE AND j.delayed_job = DBSIMPLE_ERROR_NO_VALUE AND (j.member_job = DBSIMPLE_ERROR_NO_VALUE OR j.verified = 0) AND jc.company_id = DBSIMPLE_ERROR_NO_VALUE AND MATCH(`title`,`description`) AGAINST (DBSIMPLE_ERROR_NO_VALUE IN BOOLEAN MODE) GROUP BY j.DBSIMPLE_ERROR_NO_VALUE ORDER BY hl DESC, j.posted_date DESC LIMIT DBSIMPLE_ERROR_NO_VALUE, DBSIMPLE_ERROR_NO_VALUE

SELECT SQL_CALC_FOUND_ROWS DISTINCT(j.id),`j`.`id`, `j`.`posted_date`, `j`.`title`, `j`.`empl`AS organization, `j`.`deadline_date`AS deadline, `j`.`source`, `j`.`verified`, `j`.`member_job`, `j`.`devaid_ct_email`, `j`.`expired`, `j`.`locations_srt`AS location, `jc`.`highlight`AS hl, `jc`.`company_id`, `jv`.`views`AS hits FROM v2_jobs j LEFT JOIN v2_job_company jc ON j.id = jc.job_id LEFT JOIN v2_job_views jv ON j.id = jv.job_id LEFT JOIN v2_job_locations jl ON j.id = jl.job_id LEFT JOIN v2_job_langs jln ON j.id = jln.job_id WHERE 1=1 AND j.active = 1 AND j.verified = 1 AND j.member_job = 0 AND j.expired = 0 ORDER BY hl DESC, j.posted_date DESC LIMIT 0, 10

14: -- 189 ms; returned 10 row(s)

SELECT FOUND_ROWS()

15: -- 0 ms; returned ('181')

SELECT COUNT(*) FROM v2_jobs j WHERE 1=1 AND j.active = 1 AND j.verified = 1 AND j.expired = 0

16: -- 0 ms; returned ('191')

SELECT * FROM v2_sectors WHERE 1=1 AND active = 1 ORDER BY name ASC

17: -- 1 ms; returned 83 row(s)

SELECT r.id as ARRAY_KEY_1, r.name FROM v2_regions r WHERE r.active=1 ORDER BY r.name

18: -- 0 ms; returned 6 row(s)

SELECT c.region_id as ARRAY_KEY_1, c.id as ARRAY_KEY_2, c.name, c.abbr FROM v2_countries c WHERE c.active=1 AND c.id != 246 ORDER BY c.name

19: -- 2 ms = 0+0+2; returned 245 row(s)

SELECT id AS ARRAY_KEY, name FROM v2_languages ORDER BY name ASC

20: -- 1 ms = 0+0+1; returned 287 row(s)

-- CACHE: 24h SELECT l.id AS ARRAY_KEY, l.name, COUNT(jl.lang_id) AS 'lang' FROM v2_job_langs jl LEFT JOIN v2_languages l ON l.id=jl.lang_id GROUP BY jl.lang_id ORDER BY `lang` DESC LIMIT 5

21: -- 0 ms; returned 5 row(s)