SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463871 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463871 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141728,867637,809946,536124,106737,871096,32674,142781,690650,686648,176765,39901,7017,280198,996312,830652,492817,1006402,227298,180957,560642,107050,381981,227347,1039778,932814,211727,354112,196102,459506,98946,529512,542607,408242,779782,513831,849040,981267,384235,268870,86850,102041,742135,178446,698044,948473,908551,955748,747891,460442,674791,231859,841795,999334,791709,495199,607015,29725,457646,417726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]