SHOW FULL COLUMNS FROM `city` [ RunTime:0.000907s ]
SELECT * FROM `city` WHERE `cityid` = 83 LIMIT 1 [ RunTime:0.000193s ]
SHOW FULL COLUMNS FROM `carpool` [ RunTime:0.000636s ]
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`.`carpoolid` = '179' LIMIT 1 [ RunTime:0.000362s ]
