SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39070 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39070 [ RunTime:0.002923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401315,897836,916680,216377,1048633,626344,719272,877125,901876,711796,765457,73203,849383,483023,275686,309274,585444,491928,255001,628065,90473,886674,483130,951763,780975,259082,94653,393411,1000129,189011,960325,328799,1018190,591227,686070,739375,591853,890953,24346,706364,295967,318856,308251,913071,923770,910510,509757,811526,61098,617906,498467,368523,100562,235208,794847,226924,657743,440928,23340,857849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]