SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500411 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500411 [ RunTime:0.002463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547640,880114,934820,938271,498860,287703,1004375,579940,750332,842891,591483,901135,871893,930542,472259,348596,622674,672205,733351,390513,854400,659128,533873,342176,692621,896641,619369,511981,841260,514196,907938,829805,770296,811881,1044411,995024,77693,396157,233553,1016944,784551,367923,129571,823169,115555,81563,1026468,999332,337388,264950,408069,755757,20530,286815,774015,783847,743754,89802,968833,956376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]