В Вашем браузере отключены Cookies. Для правильной работы сайта Cookies необходимо включить!
SELECT SQL_CACHE * FROM job_section WHERE token IN ('active') ORDER BY sort ASC,id ASC,name ASC
SELECT SQL_CACHE section.id,COUNT(DISTINCT vacancy.id) AS cnt_vacancy FROM job_section AS section LEFT JOIN job_vacancy AS vacancy ON vacancy.id_section IN (section.id) WHERE section.token IN ('active') AND vacancy.token IN('active') GROUP BY section.id ORDER BY section.sort ASC,section.id ASC,section.name ASC
SELECT SQL_CACHE section.id,COUNT(DISTINCT resume_v.id) AS cnt_resume_v FROM job_section AS section LEFT JOIN job_resume AS resume_v ON resume_v.id_section IN (section.id) WHERE section.token IN ('active') AND resume_v.token IN ('active') AND resume_v.visibility IN ('visible','visiblehc') GROUP BY section.id ORDER BY section.sort ASC,section.id ASC,section.name ASC
SELECT SQL_CACHE section.id,COUNT(DISTINCT resume_m.id) AS cnt_resume_m FROM job_section AS section LEFT JOIN job_resume AS resume_m ON resume_m.id_section IN (section.id) WHERE section.token IN ('active') AND resume_m.token IN ('active') AND resume_m.visibility IN ('visible','visiblehc','members','membershc') GROUP BY section.id ORDER BY section.sort ASC,section.id ASC,section.name ASC
SELECT SQL_CACHE * FROM main_region WHERE token IN ('active') ORDER BY sort ASC,name ASC,id ASC
SELECT SQL_CACHE region.id,COUNT(DISTINCT vacancy.id) AS cnt_vacancy FROM main_region AS region LEFT JOIN job_vacancy AS vacancy ON vacancy.id_region IN (region.id) WHERE region.token IN ('active') AND vacancy.token IN('active') GROUP BY region.id ORDER BY region.sort ASC,region.name ASC,region.id ASC
SELECT SQL_CACHE region.id,COUNT(DISTINCT resume_v.id) AS cnt_resume_v FROM main_region AS region LEFT JOIN job_resume AS resume_v ON resume_v.id_region IN (region.id) WHERE region.token IN ('active') AND resume_v.token IN ('active') AND resume_v.visibility IN ('visible','visiblehc') GROUP BY region.id ORDER BY region.sort ASC,region.name ASC,region.id ASC
SELECT SQL_CACHE region.id,COUNT(DISTINCT resume_m.id) AS cnt_resume_m FROM main_region AS region LEFT JOIN job_resume AS resume_m ON resume_m.id_region IN (region.id) WHERE region.token IN ('active') AND resume_m.token IN ('active') AND resume_m.visibility IN ('visible','visiblehc','members','membershc') GROUP BY region.id ORDER BY region.sort ASC,region.name ASC,region.id ASC
SELECT id,title FROM job_pages WHERE token IN ('active') ORDER BY sort ASC
SELECT SQL_CACHE * FROM job_groups WHERE id IN ('guest') AND token IN ('active') LIMIT 0, 1
SELECT SQL_CACHE * FROM job_groups_resp WHERE id IN ('guest') AND token IN ('active') LIMIT 0, 1
SELECT SQL_CACHE * FROM job_profession WHERE token IN ('active') ORDER BY parent_id ASC,sort ASC,id ASC,name ASC
SELECT SQL_CACHE profession.id,COUNT(DISTINCT vacancy.id) AS cnt_vacancy FROM job_profession AS profession LEFT JOIN job_vacancy AS vacancy ON vacancy.id_profession IN (profession.id) WHERE profession.token IN ('active') AND vacancy.token IN('active') GROUP BY profession.id ORDER BY profession.parent_id ASC,profession.sort ASC,profession.id ASC,profession.name ASC
SELECT SQL_CACHE profession.id,COUNT(DISTINCT resume_v.id) AS cnt_resume_v FROM job_profession AS profession LEFT JOIN job_resume AS resume_v ON resume_v.id_profession IN (profession.id) OR resume_v.id_profession_1 IN (profession.id) OR resume_v.id_profession_2 IN (profession.id) WHERE profession.token IN ('active') AND resume_v.token IN ('active') AND resume_v.visibility IN ('visible','visiblehc') GROUP BY profession.id ORDER BY profession.parent_id ASC,profession.sort ASC,profession.id ASC,profession.name ASC
SELECT SQL_CACHE profession.id,COUNT(DISTINCT resume_m.id) AS cnt_resume_m FROM job_profession AS profession LEFT JOIN job_resume AS resume_m ON resume_m.id_profession IN (profession.id) OR resume_m.id_profession_1 IN (profession.id) OR resume_m.id_profession_2 IN (profession.id) WHERE profession.token IN ('active') AND resume_m.token IN ('active') AND resume_m.visibility IN ('visible','visiblehc','members','membershc') GROUP BY profession.id ORDER BY profession.parent_id ASC,profession.sort ASC,profession.id ASC,profession.name ASC
SELECT SQL_CACHE * FROM main_city WHERE token IN ('active') ORDER BY parent_id ASC,capital ASC,name ASC,id ASC
SELECT SQL_CACHE city.id,COUNT(DISTINCT vacancy.id) AS cnt_vacancy FROM main_city AS city LEFT JOIN job_vacancy AS vacancy ON vacancy.id_city IN (city.id) WHERE city.token IN ('active') AND vacancy.token IN('active') GROUP BY city.id ORDER BY city.parent_id ASC,city.capital ASC,city.name ASC,city.id ASC
SELECT SQL_CACHE city.id,COUNT(DISTINCT resume_v.id) AS cnt_resume_v FROM main_city AS city LEFT JOIN job_resume AS resume_v ON resume_v.id_city IN (city.id) WHERE city.token IN ('active') AND resume_v.token IN ('active') AND resume_v.visibility IN ('visible','visiblehc') GROUP BY city.id ORDER BY city.parent_id ASC,city.capital ASC,city.name ASC,city.id ASC
SELECT SQL_CACHE city.id,COUNT(DISTINCT resume_m.id) AS cnt_resume_m FROM main_city AS city LEFT JOIN job_resume AS resume_m ON resume_m.id_city IN (city.id) WHERE city.token IN ('active') AND resume_m.token IN ('active') AND resume_m.visibility IN ('visible','visiblehc','members','membershc') GROUP BY city.id ORDER BY city.parent_id ASC,city.capital ASC,city.name ASC,city.id ASC
SELECT SQL_CALC_FOUND_ROWS * FROM job_vacancy WHERE vip AND token IN ('active') ORDER BY rate DESC,vip_unset_datetime DESC,RAND() LIMIT 0, 5
SELECT FOUND_ROWS()
SELECT SQL_CACHE * FROM job_vacancy WHERE !vip AND !hot AND token IN ('active') ORDER BY act_datetime DESC LIMIT 0, 10
SELECT id,title,small_text,datetime FROM job_news WHERE token IN ('active') AND datetime<=NOW() ORDER BY datetime DESC LIMIT 0, 3
SELECT SQL_CACHE SQL_CALC_FOUND_ROWS conf_users.id,conf_users.company_name,conf_users.company_city,conf_users.logo FROM main_users AS users LEFT JOIN job_conf_users AS conf_users ON users.id=conf_users.id WHERE conf_users.main_logo AND conf_users.logo!='' AND conf_users.token IN ('active') AND conf_users.user_type IN ('company') GROUP BY users.id ORDER BY conf_users.sort_logo ASC
SELECT SQL_CALC_FOUND_ROWS * FROM job_vacancy WHERE hot AND token IN ('active') ORDER BY rate DESC,hot_unset_datetime DESC,RAND() LIMIT 0, 5
SELECT FOUND_ROWS()
SELECT SQL_CACHE COUNT(id) as num_rows FROM job_conf_users WHERE token IN ('active')
SELECT SQL_CACHE COUNT(id) as num_rows FROM job_vacancy WHERE token IN ('active')
SELECT SQL_CACHE COUNT(id) as num_rows FROM job_resume WHERE token IN ('active') AND visibility IN ('visible','visiblehc')
SELECT SQL_CACHE COUNT(id) as num_rows FROM job_resume WHERE token IN ('active') AND visibility IN ('visible','visiblehc','members','membershc')
