SHOW FULL COLUMNS FROM `city` [ RunTime:0.000856s ]
SELECT * FROM `city` WHERE `cityid` = 83 LIMIT 1 [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `carpool` [ RunTime:0.000610s ]
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` > '2025-11-14 22:34:37' AND ( `a`.`begincityid` = '83' OR `a`.`endcityid` = '83' ) ) ORDER BY `a`.`updatetime` DESC LIMIT 0,20 [ RunTime:0.000430s ]
SELECT COUNT(*) AS think_count FROM `carpool` WHERE ( `setoffdate` > '2025-11-14 22:34:37' AND ( `begincityid` = 83 OR `endcityid` = 83 ) ) LIMIT 1 [ RunTime:0.000303s ]
