SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80423 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80423 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943518,421300,865523,482869,990312,147039,433735,123740,553325,828384,120643,44419,175741,416364,978803,631006,726893,464396,137398,550734,660953,714428,703445,323151,708294,356321,120578,128721,687300,479618,716536,734415,13354,427489,426190,270313,676756,815669,792627,868864,672541,686370,425930,976094,835109,237836,699309,14581,440762,21591,501410,1040821,692118,390314,735039,469301,935076,825174,512293,720438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]