SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419980 LIMIT 1 [ RunTime:0.001399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419980 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84391,689853,423957,205473,184900,714866,426260,57445,846615,421145,459861,3640,419655,296705,561268,838670,82493,1019563,36544,576517,783699,157804,877127,1036331,1028687,844136,445767,688708,123918,2088,810584,507484,261278,259223,843879,262861,96692,147084,840858,797876,595146,385363,949187,351752,660885,801030,960722,95325,909279,709537,330146,130901,366870,269320,702607,978874,1037867,452861,310266,120802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]