SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567741 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567741 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376782,149410,464949,32128,683118,463853,145394,230221,806782,242529,564571,19929,613233,496274,575633,851655,5317,309297,778663,333517,356711,823581,412311,1045909,839332,84862,766396,53510,88941,750228,287412,334982,51042,289921,792238,705295,1037238,14475,41539,442891,808421,492795,398727,969280,430300,24085,515229,273726,22621,551135,920158,922382,481626,572574,532835,866031,1025221,583426,394469,35875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]