SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518593 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518593 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40116,529036,1004351,12278,460929,574598,9864,433113,365679,947731,197805,196426,605900,922228,552519,706123,357979,111922,128570,479226,775627,835228,510961,716811,121048,856165,954739,485902,508039,869933,75905,176386,588935,542766,3449,742943,299169,319228,535721,539277,649270,784521,895535,496136,624442,306903,453316,422544,413450,1019880,268039,102903,576270,383623,138993,1009592,876839,120321,896523,167866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]