SHOW FULL COLUMNS FROM `qyt_single_page` [ RunTime:0.000829s ]
SELECT `itemid`,`title` FROM `qyt_single_page` [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `qyt_system` [ RunTime:0.000976s ]
SELECT `itemid`,`websiteName`,`websiteLogo`,`websiteCopyright`,`websitePhone`,`websiteQQ`,`websiteFooter`,`serviceFee`,`taxRate`,`rbRate`,`paRate`,`fee`,`isagent`,`isexamine`,`issafetytraining`,`isuploadwaybill`,`isshippingexam`,`issendgoodsfence`,`isreceivegoodsfence`,`Insurance`,`oilRate`,`examine`,`storage`,`appdownQrcode`,`isReceivegoods`,`isRefund` FROM `qyt_system` WHERE `itemid` = 1 LIMIT 1 [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `qyt_truck` [ RunTime:0.001096s ]
SELECT t.userid,t.itemid,t.Name,t.Phone,t.NumberId,t.addtime,t.Weight,t.caritemid,
getname(t.StartProvinceId) as StartProvince,getname(t.StartCityId) as StartCity,getname(t.StartDistrictId) as StartDistrict,
getname(t.EndProvinceId) as EndProvince,getname(t.EndCityId) as EndCity,getname(t.EndDistrictId) as EndDistrict,
tt.type as cartype,ts.size as carsize,t.introduce,t.StartCityId,t.EndCityId FROM `qyt_truck` `t` LEFT JOIN `qyt_truck_type` `tt` ON `tt`.`itemid`=`t`.`VehicleTypeId` LEFT JOIN `qyt_truck_size` `ts` ON `ts`.`itemId`=`t`.`VehicleSizeId` WHERE `t`.`itemid` = '17808' LIMIT 1 [ RunTime:0.000908s ]
SHOW FULL COLUMNS FROM `qyt_member` [ RunTime:0.001475s ]
SELECT `truename`,`company` FROM `qyt_member` WHERE `userid` IS NULL LIMIT 1 [ RunTime:0.000286s ]
SELECT COUNT(*) AS think_count FROM `qyt_truck` `t` LEFT JOIN `qyt_truck_type` `tt` ON `tt`.`itemid`=`t`.`VehicleTypeId` LEFT JOIN `qyt_truck_size` `ts` ON `ts`.`itemId`=`t`.`VehicleSizeId` WHERE `t`.`StartCityId` IS NULL AND `t`.`EndCityId` IS NULL LIMIT 1 [ RunTime:0.008349s ]
SELECT t.itemid,getname(t.StartProvinceId) as StartProvince,getname(t.StartCityId) as StartCity,getname(t.EndProvinceId) as EndProvince,getname(t.EndCityId) as EndCity FROM `qyt_truck` `t` LEFT JOIN `qyt_truck_type` `tt` ON `tt`.`itemid`=`t`.`VehicleTypeId` LEFT JOIN `qyt_truck_size` `ts` ON `ts`.`itemId`=`t`.`VehicleSizeId` WHERE `t`.`userid` IS NULL ORDER BY `t`.`itemid` DESC LIMIT 10 [ RunTime:0.000585s ]