SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290314 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290314 [ RunTime:0.002870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128957,10710,820186,369174,595193,13574,794506,803346,740045,1048267,237057,1044305,531885,970095,556225,376651,677474,281026,275931,782852,643166,614873,35225,317723,281733,150952,730545,611831,197142,999968,493544,960087,214803,853464,553191,900422,647543,608173,1041739,904163,556268,49964,591203,996207,246432,970931,657230,610820,53467,33449,481496,589729,16201,201759,119399,180324,693945,431783,429252,117792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]