SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861063 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861063 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584166,113109,89630,755790,85406,942621,556353,311249,578820,601638,410552,517070,1039876,154555,267211,614867,835252,51401,765903,425810,287350,360870,428046,898,324690,375910,890294,325657,386367,168870,893208,777626,450344,325642,275415,122624,564254,144590,315831,579544,541718,400826,412340,709520,686136,139210,963539,366418,527151,1016378,283303,811645,281347,741917,937398,904657,302178,433457,345215,674148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]