SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003654s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519514 LIMIT 1 [ RunTime:0.000953s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519514 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783180,330162,625835,534445,196837,830460,116025,402299,443051,448438,490348,425080,881523,609249,933796,470292,630009,346488,17950,697150,699742,623691,248848,176467,483341,60752,123673,168210,77504,853319,594116,831901,300521,485092,494278,288307,147102,946061,223422,542886,894206,41696,201724,149233,284262,790586,991173,76437,89372,249181,250261,873784,348531,559907,730977,678946,290712,527365,249856,386303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]