SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.000911s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.000793s ]
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` = '8617' LIMIT 1 [ RunTime:0.000394s ]
UPDATE `xin_company` SET `clicks` = clicks+1 WHERE `id` = '8617' [ RunTime:0.002200s ]
SELECT `q`.*,c.title as company_name,r.name as city_name,`c`.`province`,`c`.`city` FROM `xin_quotation` `q` LEFT JOIN `xin_company` `c` ON `c`.`id`=`q`.`company_id` LEFT JOIN `xin_region` `r` ON `r`.`id`=`c`.`city` WHERE `q`.`id` = '154137' AND `q`.`company_id` = '8617' LIMIT 1 [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `xin_post` [ RunTime:0.000648s ]
SELECT `p`.*,`u`.`nickname` FROM `xin_post` `p` INNER JOIN `xin_user` `u` ON `u`.`id`=`p`.`user_id` WHERE json_unquote(json_extract(`content`, '$.id')) = '154137' AND `p`.`type` = '0' AND `p`.`is_show` = '1' AND `p`.`is_del` = '0' [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `xin_adver` [ RunTime:0.000727s ]
SELECT * FROM `xin_adver` WHERE `status` = 1 AND `position_id` = 2 AND ( `province_id` = '33' AND `city_id` = '3301' ) [ RunTime:0.000199s ]