1: 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 cd.name ASC LIMIT DBSIMPLE_ERROR_NO_VALUE, DBSIMPLE_ERROR_NO_VALUE

SELECT SQL_CALC_FOUND_ROWS `c`.`id`, `cd`.`name`, `cd`.`description`, `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 ci.member = 1 GROUP BY c.id ORDER BY cd.name ASC LIMIT 0, 10

2: -- 14 ms; returned 4 row(s)

SELECT FOUND_ROWS()

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

-- CACHE: 10m SELECT DISTINCT(e.id), ei.first_name, ei.last_name, c.name AS `country`, ei.work_experience_since,ei.description, dt.name AS 'degree' FROM v2_broadcast_cv bc LEFT JOIN v2_experts e ON e.id = bc.expert_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 INNER JOIN v2_countries c ON c.id = ei.nationality WHERE e.active = 1 AND e.suspended = 0 AND bc.brd_time > DATE_SUB(NOW(),INTERVAL 2 MONTH) AND bc.done = 1 ORDER BY RAND() LIMIT 15

4: -- 2 ms; returned 0 row(s)

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

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

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