SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423412 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423412 [ RunTime:0.003501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924129,794394,578046,576679,160780,308873,1038594,413438,520080,281393,511395,11916,140970,282393,901023,949438,204668,878382,484282,126918,481892,988476,442562,932729,510760,537675,1018028,389228,985196,874532,528106,260144,880382,779074,167059,1013584,723567,925699,60590,572181,306354,131889,42727,70228,43722,965658,939925,156171,735251,754471,161260,762932,470811,575505,268563,548106,967448,684375,105997,881660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]