SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392916 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392916 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300684,721588,665492,27590,487484,686117,713409,739830,413130,752219,267398,629815,232775,446353,361928,982566,857254,756635,396035,914420,597148,885138,348113,997864,946298,1012123,15576,15618,625066,83934,281714,454581,19065,967994,668523,4627,424438,309190,411274,1034104,231781,825942,350078,728472,997479,866904,159673,427621,157226,972926,870278,471377,750456,597117,432133,602254,138450,111875,38765,202825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]