SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.001298s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.000975s ]
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` = '14337' LIMIT 1 [ RunTime:0.000480s ]
UPDATE `xin_company` SET `clicks` = clicks+1 WHERE `id` = '14337' [ RunTime:0.003304s ]
SELECT * FROM `xin_quotation` WHERE `company_id` = '14337' ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.000296s ]
SELECT COUNT(*) AS think_count FROM `xin_quotation` WHERE `company_id` = '14337' [ RunTime:0.000142s ]
