SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516199 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516199 [ RunTime:0.003204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317019,155242,485264,455118,451222,427399,733942,799106,460773,368558,987847,337562,773545,326908,637117,366729,327060,169734,1006778,484105,216183,396036,78022,556733,808545,456990,8874,14797,32502,358861,110058,952232,357130,700524,43177,182317,691568,249401,290594,286488,916577,371807,762649,1003958,420634,132878,627147,268151,492427,328478,565829,524403,733412,534241,1043569,557886,154425,1037514,318629,502976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]