SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304978 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304978 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540310,366820,949303,678615,114685,540201,135974,686060,972662,1001254,68862,997836,339599,1048006,508164,1003170,9976,347122,1002480,838814,875619,536685,510122,380965,943945,203137,1039093,361418,492301,586749,93924,170596,237391,1012501,320272,884620,256934,665304,401084,338097,277184,131505,358593,580120,653319,508763,537375,59987,168083,804903,258303,322852,328428,104289,558428,447779,494907,83196,711098,150249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000792s ]