SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347531 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347531 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146604,836456,907529,198706,815030,317100,211677,899889,441296,784880,225842,83363,121295,803090,235247,867002,213421,377967,963708,961156,163864,308552,789087,689624,306086,888275,883291,966990,898021,375624,531073,33160,838046,346438,608071,461850,906580,240836,1011212,956713,924841,905601,285188,597944,707354,584345,938653,759366,906604,680473,835285,386669,660397,494751,1028421,924,804812,425414,602512,1039707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]