SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.001293s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.000977s ]
SELECT c.*,r.name as city_name,IF(m.id IS NULL,false,true) as is_claim, IF(l.id IS NULL,false,true) as is_collect, u.group_id FROM `xin_company` `c` LEFT JOIN `xin_claim` `m` ON `m`.`company_id`=c.id and m.status=1 LEFT JOIN `xin_collect` `l` ON `l`.`company_id`=c.id and l.user_id=0 LEFT JOIN `xin_region` `r` ON `r`.`id`=`c`.`city` LEFT JOIN `xin_user` `u` ON `u`.`id`=`c`.`user_id` WHERE `c`.`id` = '14112' LIMIT 1 [ RunTime:0.000465s ]
UPDATE `xin_company` SET `clicks` = clicks+1 WHERE `id` = '14112' [ RunTime:0.003068s ]