SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268957 LIMIT 1 [ RunTime:0.000658s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268957 [ RunTime:0.005321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975872,526328,978892,787705,842314,879486,940886,824358,322916,209342,897273,1029778,138095,865206,592375,801738,1043023,413956,895478,37450,334278,406388,373590,1021782,487017,261639,264872,169109,358414,486720,395981,626756,629141,406755,305731,721335,304237,688590,831536,607410,78245,873965,804068,398672,243601,704616,997511,357118,729856,1033783,614366,1020706,169329,198712,867057,236641,153215,497518,733795,919537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]