SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329900 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329900 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831682,342206,742917,634046,414836,692755,123904,769185,615131,42131,431170,103143,412944,81454,565524,56633,192025,996469,561835,708743,551974,239108,665980,782237,77245,555153,1039650,223240,935807,910838,367051,297935,641133,360708,720499,409716,57842,740007,939116,508161,50313,706267,227253,652039,473033,555706,469038,842800,979665,1014109,864019,84256,700155,606635,616393,156122,836273,1034835,522443,35618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]