SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525169 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525169 [ RunTime:0.003734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327098,665531,1021976,697785,230969,1027344,221402,1010359,703752,395402,326734,746873,42598,281548,750706,477329,944944,250721,393808,65798,812395,752692,604453,937050,972483,502582,963076,1043186,40471,961323,757126,181573,593536,223196,28687,899626,162735,1876,767897,783170,157783,514286,225784,998562,914576,352214,921131,380327,140157,236732,485916,188219,782148,218166,770216,861464,161077,741860,924164,257164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]