SHOW FULL COLUMNS FROM `xy_gig_jobs` [ RunTime:0.000579s ]
SELECT jobs.id,jobs.uid,jobs.company_id,jobs.title,jobs.salary,jobs.salary_type,jobs.salary_cycle,jobs.jobs_cate_id1,jobs.jobs_cate_id2,jobs.jobs_cate_id3,jobs.number_of_recruiters,jobs.start_time,jobs.end_time,jobs.refresh_time,jobs.top,jobs.ip_country,jobs.ip_province,jobs.ip_city,user.nickname,user.headimg,contacts.contacts,contacts.contacts_mobile,contacts.area_id1,contacts.area_id2,contacts.area_id3,contacts.address,area1.title as province,area2.title as city,area3.title as area,jobs_cate1.title as jobs_cate_title1,jobs_cate2.title as jobs_cate_title2,jobs_cate3.title as jobs_cate_title3,salary_type.title as salary_type_title,salary_cycle.title as salary_cycle_title,company.title as company_name,company.logo as company_logo,`content`.`content`,gig_amap.id as amap_id,gig_amap.area1,gig_amap.area2,gig_amap.area3,gig_amap.loca_name,gig_amap.street,gig_amap.street_desc,gig_amap.dimension FROM `xy_gig_jobs` `jobs` INNER JOIN `xy_gig_jobs_content` `content` ON `content`.`jobs_id`=`jobs`.`id` INNER JOIN `xy_gig_user` `user` ON `user`.`id`=`jobs`.`uid` INNER JOIN `xy_gig_jobs_contacts` `contacts` ON `contacts`.`jobs_id`=`jobs`.`id` LEFT JOIN `xy_gig_company` `company` ON `company`.`id`=`jobs`.`company_id` LEFT JOIN `xy_area` `area1` ON `area1`.`id`=`contacts`.`area_id1` LEFT JOIN `xy_area` `area2` ON `area2`.`id`=`contacts`.`area_id2` LEFT JOIN `xy_area` `area3` ON `area3`.`id`=`contacts`.`area_id3` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate1` ON `jobs_cate1`.`id`=`jobs`.`jobs_cate_id1` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate2` ON `jobs_cate2`.`id`=`jobs`.`jobs_cate_id2` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate3` ON `jobs_cate3`.`id`=`jobs`.`jobs_cate_id3` LEFT JOIN `xy_gig_amap` `gig_amap` ON `jobs`.`amap_id`=`gig_amap`.`id` INNER JOIN `xy_status_alias` `salary_type` ON `salary_type`.`value`=jobs.salary_type AND salary_type.alias="jobs/salary_type" INNER JOIN `xy_status_alias` `salary_cycle` ON `salary_cycle`.`value`=jobs.salary_cycle AND salary_cycle.alias="jobs/salary_cycle" WHERE ( `jobs`.`id` = '4' AND `jobs`.`status` = 1 AND `jobs`.`examine` = 1 AND `jobs`.`pay_status` = 1 ) AND `jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000901s ]
SELECT COUNT(*) AS think_count FROM `xy_gig_jobs` `jobs` INNER JOIN `xy_gig_user` `user` ON `user`.`id`=`jobs`.`uid` LEFT JOIN `xy_gig_company` `company` ON `company`.`id`=`jobs`.`company_id` INNER JOIN `xy_gig_jobs_contacts` `contacts` ON `contacts`.`jobs_id`=`jobs`.`id` LEFT JOIN `xy_area` `area1` ON `area1`.`id`=`contacts`.`area_id1` LEFT JOIN `xy_area` `area2` ON `area2`.`id`=`contacts`.`area_id2` LEFT JOIN `xy_area` `area3` ON `area3`.`id`=`contacts`.`area_id3` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate1` ON `jobs_cate1`.`id`=`jobs`.`jobs_cate_id1` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate2` ON `jobs_cate2`.`id`=`jobs`.`jobs_cate_id2` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate3` ON `jobs_cate3`.`id`=`jobs`.`jobs_cate_id3` INNER JOIN `xy_status_alias` `salary_type` ON `salary_type`.`value`=jobs.salary_type AND salary_type.alias="jobs/salary_type" INNER JOIN `xy_status_alias` `salary_cycle` ON `salary_cycle`.`value`=jobs.salary_cycle AND salary_cycle.alias="jobs/salary_cycle" WHERE ( `jobs`.`id` <> 4 AND `jobs`.`status` = 1 AND `jobs`.`examine` = 1 AND `jobs`.`pay_status` = 1 ) AND `jobs`.`delete_time` IS NULL [ RunTime:0.000760s ]
SELECT jobs.id,jobs.uid,jobs.company_id,jobs.title,jobs.salary,jobs.salary_type,jobs.salary_cycle,jobs.jobs_cate_id1,jobs.jobs_cate_id2,jobs.jobs_cate_id3,jobs.number_of_recruiters,jobs.start_time,jobs.end_time,jobs.browse_num,jobs.refresh_time,jobs.top,user.nickname,user.headimg,company.title as company_name,contacts.contacts,contacts.contacts_mobile,contacts.address,area1.title as province,area2.title as city,area3.title as area,jobs_cate1.title as jobs_cate_title1,jobs_cate2.title as jobs_cate_title2,jobs_cate3.title as jobs_cate_title3,salary_type.title as salary_type_title,salary_cycle.title as salary_cycle_title FROM `xy_gig_jobs` `jobs` INNER JOIN `xy_gig_user` `user` ON `user`.`id`=`jobs`.`uid` LEFT JOIN `xy_gig_company` `company` ON `company`.`id`=`jobs`.`company_id` INNER JOIN `xy_gig_jobs_contacts` `contacts` ON `contacts`.`jobs_id`=`jobs`.`id` LEFT JOIN `xy_area` `area1` ON `area1`.`id`=`contacts`.`area_id1` LEFT JOIN `xy_area` `area2` ON `area2`.`id`=`contacts`.`area_id2` LEFT JOIN `xy_area` `area3` ON `area3`.`id`=`contacts`.`area_id3` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate1` ON `jobs_cate1`.`id`=`jobs`.`jobs_cate_id1` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate2` ON `jobs_cate2`.`id`=`jobs`.`jobs_cate_id2` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate3` ON `jobs_cate3`.`id`=`jobs`.`jobs_cate_id3` INNER JOIN `xy_status_alias` `salary_type` ON `salary_type`.`value`=jobs.salary_type AND salary_type.alias="jobs/salary_type" INNER JOIN `xy_status_alias` `salary_cycle` ON `salary_cycle`.`value`=jobs.salary_cycle AND salary_cycle.alias="jobs/salary_cycle" WHERE ( `jobs`.`id` <> 4 AND `jobs`.`status` = 1 AND `jobs`.`examine` = 1 AND `jobs`.`pay_status` = 1 ) AND `jobs`.`delete_time` IS NULL ORDER BY `jobs`.`top` DESC,`jobs`.`refresh_time` DESC,`jobs`.`id` DESC LIMIT 0,15 [ RunTime:0.000856s ]
SELECT COUNT(*) AS think_count FROM `xy_gig_jobs` `jobs` INNER JOIN `xy_gig_user` `user` ON `user`.`id`=`jobs`.`uid` LEFT JOIN `xy_gig_company` `company` ON `company`.`id`=`jobs`.`company_id` INNER JOIN `xy_gig_jobs_contacts` `contacts` ON `contacts`.`jobs_id`=`jobs`.`id` LEFT JOIN `xy_area` `area1` ON `area1`.`id`=`contacts`.`area_id1` LEFT JOIN `xy_area` `area2` ON `area2`.`id`=`contacts`.`area_id2` LEFT JOIN `xy_area` `area3` ON `area3`.`id`=`contacts`.`area_id3` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate1` ON `jobs_cate1`.`id`=`jobs`.`jobs_cate_id1` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate2` ON `jobs_cate2`.`id`=`jobs`.`jobs_cate_id2` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate3` ON `jobs_cate3`.`id`=`jobs`.`jobs_cate_id3` INNER JOIN `xy_status_alias` `salary_type` ON `salary_type`.`value`=jobs.salary_type AND salary_type.alias="jobs/salary_type" INNER JOIN `xy_status_alias` `salary_cycle` ON `salary_cycle`.`value`=jobs.salary_cycle AND salary_cycle.alias="jobs/salary_cycle" WHERE ( `jobs`.`jobs_cate_id1` = 42 AND `jobs`.`id` <> 4 AND `jobs`.`status` = 1 AND `jobs`.`examine` = 1 AND `jobs`.`pay_status` = 1 ) AND `jobs`.`delete_time` IS NULL [ RunTime:0.000639s ]
SELECT jobs.id,jobs.uid,jobs.company_id,jobs.title,jobs.salary,jobs.salary_type,jobs.salary_cycle,jobs.jobs_cate_id1,jobs.jobs_cate_id2,jobs.jobs_cate_id3,jobs.number_of_recruiters,jobs.start_time,jobs.end_time,jobs.browse_num,jobs.refresh_time,jobs.top,user.nickname,user.headimg,company.title as company_name,contacts.contacts,contacts.contacts_mobile,contacts.address,area1.title as province,area2.title as city,area3.title as area,jobs_cate1.title as jobs_cate_title1,jobs_cate2.title as jobs_cate_title2,jobs_cate3.title as jobs_cate_title3,salary_type.title as salary_type_title,salary_cycle.title as salary_cycle_title FROM `xy_gig_jobs` `jobs` INNER JOIN `xy_gig_user` `user` ON `user`.`id`=`jobs`.`uid` LEFT JOIN `xy_gig_company` `company` ON `company`.`id`=`jobs`.`company_id` INNER JOIN `xy_gig_jobs_contacts` `contacts` ON `contacts`.`jobs_id`=`jobs`.`id` LEFT JOIN `xy_area` `area1` ON `area1`.`id`=`contacts`.`area_id1` LEFT JOIN `xy_area` `area2` ON `area2`.`id`=`contacts`.`area_id2` LEFT JOIN `xy_area` `area3` ON `area3`.`id`=`contacts`.`area_id3` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate1` ON `jobs_cate1`.`id`=`jobs`.`jobs_cate_id1` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate2` ON `jobs_cate2`.`id`=`jobs`.`jobs_cate_id2` LEFT JOIN `xy_gig_jobs_cate` `jobs_cate3` ON `jobs_cate3`.`id`=`jobs`.`jobs_cate_id3` INNER JOIN `xy_status_alias` `salary_type` ON `salary_type`.`value`=jobs.salary_type AND salary_type.alias="jobs/salary_type" INNER JOIN `xy_status_alias` `salary_cycle` ON `salary_cycle`.`value`=jobs.salary_cycle AND salary_cycle.alias="jobs/salary_cycle" WHERE ( `jobs`.`jobs_cate_id1` = 42 AND `jobs`.`id` <> 4 AND `jobs`.`status` = 1 AND `jobs`.`examine` = 1 AND `jobs`.`pay_status` = 1 ) AND `jobs`.`delete_time` IS NULL ORDER BY `jobs`.`top` DESC,`jobs`.`refresh_time` DESC,`jobs`.`id` DESC LIMIT 0,15 [ RunTime:0.000725s ]