SHOW FULL COLUMNS FROM `qyt_single_page` [ RunTime:0.000739s ]
SELECT `itemid`,`title` FROM `qyt_single_page` [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `qyt_system` [ RunTime:0.000692s ]
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.000367s ]
SHOW FULL COLUMNS FROM `qyt_goods` [ RunTime:0.000912s ]
SELECT COUNT(*) AS think_count FROM `qyt_goods` `g` LEFT JOIN `qyt_goods_unit` `gu` ON `gu`.`unitId`=`g`.`UnitType` LEFT JOIN `qyt_truck_type` `tt` ON `tt`.`itemid`=`g`.`typeid` LEFT JOIN `qyt_truck_size` `ts` ON `ts`.`itemid`=`g`.`wg_truckNeeds` LEFT JOIN `qyt_order` `o` ON `o`.`goodsID`=`g`.`itemid` WHERE `g`.`Published` = '1' AND `g`.`isDel` = '1' AND `competition` = 0 AND `is_examine` = 1 AND `g`.`isDel` = '1' LIMIT 1 [ RunTime:0.009319s ]
SELECT `g`.`itemid`,`g`.`goodsName`,`g`.`goodsWeight`,`g`.`goodsVolume`,`g`.`adddate`,`g`.`enddate`,`g`.`StartProvinceId`,`g`.`StartCityId`,`g`.`StartDistrictId`,`g`.`EndProvinceId`,`g`.`EndCityId`,`g`.`EndDistrictId`,g.introduce as memo,g.Price as wg_expectationPrice,`gu`.`unitText`,`tt`.`type`,`ts`.`size`,`g`.`Published`,`g`.`StartAddress`,`g`.`EndAddress`,`g`.`unitL`,`g`.`unitT`,`g`.`unitB`,`g`.`shipperName`,g.competitionStatus as compstatus,`g`.`competition`,o.itemid as orderId,`o`.`orderType`,`o`.`orderStatus`,`g`.`goodsType`,`g`.`wg_goodsQuantity`,`o`.`createdID`,`o`.`shipperUserId` FROM `qyt_goods` `g` LEFT JOIN `qyt_goods_unit` `gu` ON `gu`.`unitId`=`g`.`UnitType` LEFT JOIN `qyt_truck_type` `tt` ON `tt`.`itemid`=`g`.`typeid` LEFT JOIN `qyt_truck_size` `ts` ON `ts`.`itemid`=`g`.`wg_truckNeeds` LEFT JOIN `qyt_order` `o` ON `o`.`goodsID`=`g`.`itemid` WHERE `g`.`Published` = '1' AND `g`.`isDel` = '1' AND `competition` = 0 AND `is_examine` = 1 AND `g`.`isDel` = '1' ORDER BY `g`.`itemid` DESC LIMIT 1240,10 [ RunTime:0.013401s ]
SHOW FULL COLUMNS FROM `qyt_company` [ RunTime:0.000646s ]
SELECT * FROM `qyt_company` ORDER BY `userid` DESC LIMIT 2 [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `qyt_truck` [ RunTime:0.000577s ]
SELECT t.Weight,t.itemid,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 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`.`Published` = '1' AND `t`.`isDel` = '1' ORDER BY `t`.`addtime` DESC LIMIT 2 [ RunTime:0.012416s ]
SHOW FULL COLUMNS FROM `qyt_unit_select` [ RunTime:0.000439s ]
SELECT `id`,`start`,`end`,`type` FROM `qyt_unit_select` WHERE `status` = 1 ORDER BY `id` ASC [ RunTime:0.000305s ]
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.000262s ]