SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320894 LIMIT 1 [ RunTime:0.000631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320894 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017584,566014,347485,1005614,189134,433321,201222,915623,494327,328797,741797,671375,300956,367239,314312,557139,971172,55786,745291,1040485,123247,339545,987438,193882,581846,610028,100458,884102,668645,566842,197085,194303,27084,569610,988326,6037,563650,604845,843672,799967,975060,680568,758074,602452,188790,83968,557294,369323,712422,787098,871877,145066,431980,1017460,502475,954441,945781,822322,313481,21563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001731s ]