SHOW FULL COLUMNS FROM `city` [ RunTime:0.000887s ]
SELECT * FROM `city` WHERE `cityid` = 83 LIMIT 1 [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `carpool` [ RunTime:0.000894s ]
SELECT `a`.*,begincity.cityname as begincityname,endcity.cityname as endcityname FROM `carpool` `a` INNER JOIN `city` `begincity` ON `begincity`.`cityid`=`a`.`begincityid` INNER JOIN `city` `endcity` ON `endcity`.`cityid`=`a`.`endcityid` WHERE ( `a`.`setoffdate` > '2026-01-02 09:32:47' AND ( `a`.`begincityid` = '83' OR `a`.`endcityid` = '83' ) ) ORDER BY `a`.`updatetime` DESC LIMIT 0,20 [ RunTime:0.000629s ]
SELECT COUNT(*) AS think_count FROM `carpool` WHERE ( `setoffdate` > '2026-01-02 09:32:47' AND ( `begincityid` = 83 OR `endcityid` = 83 ) ) LIMIT 1 [ RunTime:0.000493s ]
