SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351823 LIMIT 1 [ RunTime:0.002372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351823 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408558,876260,379995,781499,869222,544044,425119,753320,298134,154624,795644,267360,1032829,263897,561797,789238,917091,624278,161898,487944,980344,394810,755515,1015103,461267,636418,661716,296742,497475,10379,1013626,624971,474669,381553,227396,952551,657365,939795,31499,330226,584732,518951,1024187,583391,791423,352683,898380,549318,839287,1034454,1040793,1044689,672851,143458,453836,622210,785258,1044312,384160,698918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]