1: 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)

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

-- 2 ms = 1+0+1; returned 246 row(s)

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

-- 1 ms; returned 83 row(s)

4: SELECT DBSIMPLE_ERROR_NO_VALUE ,COUNT(DISTINCT DBSIMPLE_ERROR_NO_VALUE) AS open_positions FROM v2_companies c LEFT JOIN v2_company_job_hl cjh ON c.id = cjh.company_id LEFT JOIN v2_company_options co ON c.id = co.company_id LEFT JOIN v2_company_description cd ON c.id = cd.company_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_company_info ci ON c.id = ci.company_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_company_sectors cs ON c.id = cs.company_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_company_locations cl ON c.id = cl.company_id AND 1=1 LEFT JOIN v2_countries lc ON cl.location_id = lc.id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_company_docs cdes ON cdes.company_id = c.id LEFT JOIN v2_company_docs_index cdi ON cdes.id = cdi.doc_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_job_company jc ON c.id = jc.company_id AND 1=DBSIMPLE_ERROR_NO_VALUE LEFT JOIN v2_sectors sc ON cs.sector_id =sc.id WHERE 1=1 AND cd.name LIKE DBSIMPLE_ERROR_NO_VALUE AND c.register_date >= DBSIMPLE_ERROR_NO_VALUE AND cl.location_id = DBSIMPLE_ERROR_NO_VALUE AND ci.member = DBSIMPLE_ERROR_NO_VALUE AND cl.location_id IN (DBSIMPLE_ERROR_NO_VALUE) AND lc.region_id IN (DBSIMPLE_ERROR_NO_VALUE) AND ( lc.region_id IN (DBSIMPLE_ERROR_NO_VALUE) OR cl.location_id IN (DBSIMPLE_ERROR_NO_VALUE) ) AND lc.region_id = ABS(DBSIMPLE_ERROR_NO_VALUE) AND ( lc.region_id = DBSIMPLE_ERROR_NO_VALUE OR cl.location_id = DBSIMPLE_ERROR_NO_VALUE ) AND cs.sector_id IN (DBSIMPLE_ERROR_NO_VALUE) AND c.active = DBSIMPLE_ERROR_NO_VALUE AND c.suspended = DBSIMPLE_ERROR_NO_VALUE AND ( MATCH(`cd`.`description`) AGAINST (DBSIMPLE_ERROR_NO_VALUE IN BOOLEAN MODE) OR MATCH(`cd`.`highlight_skills`) AGAINST (DBSIMPLE_ERROR_NO_VALUE IN BOOLEAN MODE) OR MATCH(`cdi`.`context`) AGAINST (DBSIMPLE_ERROR_NO_VALUE IN BOOLEAN MODE) OR MATCH(`cd`.`name`) AGAINST (DBSIMPLE_ERROR_NO_VALUE IN BOOLEAN MODE) ) GROUP BY c.id ORDER BY ci.member DESC, ci.live_jobs DESC LIMIT DBSIMPLE_ERROR_NO_VALUE, DBSIMPLE_ERROR_NO_VALUE

SELECT SQL_CALC_FOUND_ROWS `c`.`id`, `cd`.`name`, `cd`.`description`, `ci`.`member`, `ci`.`live_jobs` FROM v2_companies c LEFT JOIN v2_company_job_hl cjh ON c.id = cjh.company_id LEFT JOIN v2_company_options co ON c.id = co.company_id LEFT JOIN v2_company_description cd ON c.id = cd.company_id AND 1=1 LEFT JOIN v2_company_info ci ON c.id = ci.company_id AND 1=1 LEFT JOIN v2_company_sectors cs ON c.id = cs.company_id AND 1=1 LEFT JOIN v2_company_locations cl ON c.id = cl.company_id AND 1=1 LEFT JOIN v2_countries lc ON cl.location_id = lc.id AND 1=1 LEFT JOIN v2_sectors sc ON cs.sector_id =sc.id WHERE 1=1 AND c.active = 1 AND c.suspended = 0 GROUP BY c.id ORDER BY ci.member DESC, ci.live_jobs DESC LIMIT 0, 10

5: -- 2 ms; returned 10 row(s)

SELECT FOUND_ROWS()

6: -- 0 ms; returned ('10')

-- 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 15

7: -- 2 ms; returned 5 row(s)

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

8: -- 1 ms; returned ('10')

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

9: -- 0 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

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)