SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 903281 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 903281 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028068,580061,878937,491751,280832,366249,289969,651810,99600,916076,348441,415739,442374,367961,36666,462954,375071,433013,448088,55103,1005838,1003122,1034109,561018,939020,1034325,869280,818839,369691,396705,254375,351113,484289,863071,164957,1046416,970300,986033,234395,495157,277175,611748,1042632,917937,845694,468782,712214,1005648,246406,598499,338202,568813,788598,585520,88815,586202,824229,265284,640913,774673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 903281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 903281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]