SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200305 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200305 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955054,1793,863114,1046464,752104,394918,601697,159594,943623,490978,951711,170297,333857,704344,734182,1020002,810277,250794,890626,825175,52729,583906,745263,831975,335910,765510,825005,635787,969838,200851,142979,906081,223012,742650,169373,510387,378696,782287,646285,94491,568630,449919,755494,187265,622211,444130,477008,319775,214599,146744,341926,454336,14574,735431,610327,192751,301531,122347,6640,322726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]