SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.001179s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.000903s ]
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` = '14304' LIMIT 1 [ RunTime:0.000427s ]
UPDATE `xin_company` SET `clicks` = clicks+1 WHERE `id` = '14304' [ RunTime:0.002840s ]
SELECT * FROM `xin_quotation` WHERE `company_id` = '14304' ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.000249s ]
SELECT COUNT(*) AS think_count FROM `xin_quotation` WHERE `company_id` = '14304' [ RunTime:0.000140s ]