SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427552 LIMIT 1 [ RunTime:0.000588s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427552 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452930,82638,273739,71840,833354,1178,489673,270267,934900,540624,561309,932325,264223,261742,108533,894777,659768,956016,672511,741875,88954,209622,634272,897574,941981,972048,201914,56052,17151,412101,964962,650848,23528,101612,842006,421918,2065,132122,864211,921785,1002753,133713,1036910,999617,755906,327349,398486,822116,770382,855275,157486,433227,851098,865558,475804,1039028,256521,936099,883587,492469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]