1: SELECT DISTINCT(e.id), ei.first_name, ei.last_name, ei.description, ei.gender,
dt.name AS 'highest_degree'
FROM v2_membersList m
LEFT JOIN v2_memberMembership mm ON mm.member_id = m.id
LEFT JOIN v2_membershipList ml ON mm.membership_id = ml.id
LEFT JOIN v2_membershipPermissions mp ON mp.membership_id = ml.id
LEFT JOIN v2_experts e ON e.id = m.user_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.expired = 0
AND m.expiration_date > NOW()
AND ( MATCH(`ei`.`description`) AGAINST (DBSIMPLE_ERROR_NO_VALUE IN BOOLEAN MODE) OR
MATCH(`ei`.`first_name`) AGAINST (DBSIMPLE_ERROR_NO_VALUE IN BOOLEAN MODE) OR
MATCH(`ei`.`last_name`) AGAINST (DBSIMPLE_ERROR_NO_VALUE IN BOOLEAN MODE))
AND ( c.id IN (DBSIMPLE_ERROR_NO_VALUE) OR c.region_id IN (DBSIMPLE_ERROR_NO_VALUE) )
AND c.id IN (DBSIMPLE_ERROR_NO_VALUE)
AND c.region_id IN (DBSIMPLE_ERROR_NO_VALUE)
AND mp.permission_id = DBSIMPLE_ERROR_NO_VALUE
ORDER BY m.start_date DESC
LIMIT DBSIMPLE_ERROR_NO_VALUE,DBSIMPLE_ERROR_NO_VALUE
SELECT SQL_CALC_FOUND_ROWS DISTINCT(e.id), ei.first_name, ei.last_name, ei.description, ei.gender,
dt.name AS 'highest_degree'
FROM v2_membersList m
LEFT JOIN v2_memberMembership mm ON mm.member_id = m.id
LEFT JOIN v2_membershipList ml ON mm.membership_id = ml.id
LEFT JOIN v2_membershipPermissions mp ON mp.membership_id = ml.id
LEFT JOIN v2_experts e ON e.id = m.user_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.expired = 0
AND m.expiration_date > NOW()
AND mp.permission_id = 7
ORDER BY m.start_date DESC
LIMIT 0,10
2: -- 3 ms; returned 5 row(s)
SELECT FOUND_ROWS()
3: -- 1 ms; returned ('5')
SELECT c.name
FROM v2_countries c
LEFT JOIN v2_expert_nationality en ON c.id=en.country_id
WHERE en.expert_id=10810
4: -- 0 ms; returned ('Cameroon')
SELECT c.name
FROM v2_countries c
LEFT JOIN v2_expert_nationality en ON c.id=en.country_id
WHERE en.expert_id=10772
5: -- 0 ms; returned ('Moldova')
SELECT c.name
FROM v2_countries c
LEFT JOIN v2_expert_nationality en ON c.id=en.country_id
WHERE en.expert_id=10767
6: -- 0 ms; returned ('Portugal')
SELECT c.name
FROM v2_countries c
LEFT JOIN v2_expert_nationality en ON c.id=en.country_id
WHERE en.expert_id=12
7: -- 1 ms; returned ('Cameroon')
SELECT c.name
FROM v2_countries c
LEFT JOIN v2_expert_nationality en ON c.id=en.country_id
WHERE en.expert_id=1000
8: -- 0 ms; returned ('India')
-- 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 20
9: -- 1 ms; returned 5 row(s)
SELECT r.id as ARRAY_KEY_1, r.name
FROM v2_regions r
WHERE r.active=1
ORDER BY r.name
10: -- 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
11: -- 1 ms = 0+0+1; returned 245 row(s)
