SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020086 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020086 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328664,90062,219491,921753,440941,593812,764997,695255,516040,290013,881203,523068,1022923,534595,132487,313523,809188,808174,739812,455895,923433,473557,872814,838666,892077,206354,873001,106537,62641,188876,3229,516570,42909,35465,576674,693195,298880,1023247,492603,864617,938825,449733,671515,672414,623193,865268,966612,1037339,149043,246259,405578,694574,726669,98121,177554,132734,513096,521380,907981,371358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000984s ]