1: SELECT id AS ARRAY_KEY, name FROM v2_degree_types ORDER BY sort_order ASC

-- 1 ms; returned 7 row(s)

2: SELECT DBSIMPLE_ERROR_NO_VALUE ,COUNT(DBSIMPLE_ERROR_NO_VALUE) AS `docs` FROM v2_experts e LEFT JOIN v2_expert_info ei ON e.id = ei.expert_id LEFT JOIN v2_expert_nationality en ON e.id = en.expert_id LEFT JOIN v2_expert_docs ed ON ed.expert_id = e.id LEFT JOIN v2_admin_comments_action aca on aca.user_id = e.id AND user_type = 1 AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_mdb_ddb mdb ON e.id = mdb.ddb_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_countries c ON en.country_id = c.id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_degree_types dt ON ei.highest_degree = dt.id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_sphinx_search eft ON eft.id = e.id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_expert_settings est ON est.expert_id = e.id AND 1=1 LEFT JOIN v2_expert_langs el ON e.id = el.expert_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_expert_working_sectors es ON e.id = es.expert_id AND 1=DBSIMPLE_ERROR_NO_VALUE INNER JOIN v2_expert_verified ev ON e.id = ev.expert_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_expert_verified ev ON e.id = ev.expert_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_expert_activity ea ON e.id = ea.expert_id WHERE 1=1 AND (ei.work_experience_since <= DBSIMPLE_ERROR_NO_VALUE OR ei.work_experience_since IS NULL) AND (ei.work_experience_since >= DBSIMPLE_ERROR_NO_VALUE OR ei.work_experience_since IS NULL) AND (ei.first_name LIKE DBSIMPLE_ERROR_NO_VALUE OR ei.last_name LIKE DBSIMPLE_ERROR_NO_VALUE ) AND (dt.sort_order >= DBSIMPLE_ERROR_NO_VALUE OR dt.sort_order IS NULL) AND (dt.sort_order <= DBSIMPLE_ERROR_NO_VALUE OR dt.sort_order IS NULL) AND en.country_id IN (DBSIMPLE_ERROR_NO_VALUE) AND c.region_id IN (DBSIMPLE_ERROR_NO_VALUE) AND ( en.country_id IN (DBSIMPLE_ERROR_NO_VALUE) OR c.region_id IN (DBSIMPLE_ERROR_NO_VALUE) ) AND el.lang_id IN (DBSIMPLE_ERROR_NO_VALUE) AND es.sector_id IN (DBSIMPLE_ERROR_NO_VALUE) AND e.id IN (DBSIMPLE_ERROR_NO_VALUE) AND e.active = DBSIMPLE_ERROR_NO_VALUE AND e.suspended = DBSIMPLE_ERROR_NO_VALUE AND e.register_date >= DBSIMPLE_ERROR_NO_VALUE AND aca.action = DBSIMPLE_ERROR_NO_VALUE AND aca.admin_id = DBSIMPLE_ERROR_NO_VALUE AND eft.query = DBSIMPLE_ERROR_NO_VALUE AND 1=1 AND ev.verified = DBSIMPLE_ERROR_NO_VALUE AND ( ev.verified = DBSIMPLE_ERROR_NO_VALUE OR ev.verified IS NULL ) GROUP BY e.id HAVING docs >= DBSIMPLE_ERROR_NO_VALUE ORDER BY ea.last_modified DESC LIMIT DBSIMPLE_ERROR_NO_VALUE, DBSIMPLE_ERROR_NO_VALUE

SELECT SQL_CALC_FOUND_ROWS `e`.`id`, `e`.`register_date`, `ei`.`first_name`, `ei`.`last_name`, `ei`.`work_experience_since`, `ei`.`highest_degree`, `c`.`name`AS location, `dt`.`name`AS highest_degree, `ea`.`last_modified` ,COUNT(`ed`.`id`) AS `docs` FROM v2_experts e LEFT JOIN v2_expert_info ei ON e.id = ei.expert_id LEFT JOIN v2_expert_nationality en ON e.id = en.expert_id LEFT JOIN v2_expert_docs ed ON ed.expert_id = e.id LEFT JOIN v2_countries c ON en.country_id = c.id AND 1=1 LEFT JOIN v2_degree_types dt ON ei.highest_degree = dt.id AND 1=1 LEFT JOIN v2_expert_settings est ON est.expert_id = e.id AND 1=1 LEFT JOIN v2_expert_activity ea ON e.id = ea.expert_id WHERE 1=1 AND e.active = 1 AND e.suspended = 0 AND 1=1 GROUP BY e.id ORDER BY ea.last_modified DESC LIMIT 0, 10

3: -- 1511 ms; returned 10 row(s)

SELECT FOUND_ROWS()

4: -- 0 ms; returned ('9169')

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10919

5: -- 0 ms; returned ('Burkina Faso')

SELECT * FROM v2_membersList m WHERE m.user_id = 10919 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

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

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10918

7: -- 0 ms; returned ('Moldova')

SELECT * FROM v2_membersList m WHERE m.user_id = 10918 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

8: -- 0 ms; returned 0 row(s)

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10917

9: -- 0 ms; returned ('Zimbabwe')

SELECT * FROM v2_membersList m WHERE m.user_id = 10917 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

10: -- 0 ms; returned 0 row(s)

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10916

11: -- 0 ms; returned ('Burkina Faso')

SELECT * FROM v2_membersList m WHERE m.user_id = 10916 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

12: -- 0 ms; returned 0 row(s)

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10915

13: -- 0 ms; returned ('Malawi')

SELECT * FROM v2_membersList m WHERE m.user_id = 10915 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

14: -- 0 ms; returned 0 row(s)

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 12

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

SELECT * FROM v2_membersList m WHERE m.user_id = 12 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

16: -- 0 ms; returned ('29', '12', '0', '2011-03-05 23:23:20', '2030-08-05 22:23:20', '0', '1', '0')

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10914

17: -- 0 ms; returned ('India')

SELECT * FROM v2_membersList m WHERE m.user_id = 10914 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

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

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10913

19: -- 1 ms; returned ('USA')

SELECT * FROM v2_membersList m WHERE m.user_id = 10913 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

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

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10912

21: -- 1 ms; returned ('France')

SELECT * FROM v2_membersList m WHERE m.user_id = 10912 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

22: -- 0 ms; returned 0 row(s)

SELECT c.name FROM v2_expert_nationality en LEFT JOIN v2_countries c ON c.id = en.country_id WHERE en.expert_id = 10911

23: -- 0 ms; returned ('Pakistan')

SELECT * FROM v2_membersList m WHERE m.user_id = 10911 AND m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0

24: -- 0 ms; returned 0 row(s)

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

25: -- 0 ms; returned ('9169')

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

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

27: -- 1 ms = 0+0+1; returned 245 row(s)

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

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

29: -- 1 ms; returned 5 row(s)

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

30: -- 0 ms; returned 83 row(s)

SELECT id AS ARRAY_KEY, name FROM v2_degree_types ORDER BY sort_order ASC

31: -- 0 ms; returned 7 row(s)