SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282215 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282215 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198914,687049,140046,828823,483965,1016591,760771,153497,582315,487474,485512,79381,92502,34602,710874,8847,1036117,919145,596393,490272,574378,234255,224836,591321,891449,268781,880921,978050,194249,785033,809654,665957,282909,546953,903728,723000,589949,694516,325963,124977,279762,983513,901764,770327,966863,918430,142135,687572,172723,189176,452747,126479,332957,129970,778554,921355,635970,593268,379427,613275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001538s ]