SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51606 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51606 [ RunTime:0.002319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122669,818300,722256,820101,28614,975189,134760,567499,57411,585849,7762,564483,171475,407321,465592,202428,760810,388418,1006218,50120,706473,50233,577190,972711,246700,56001,834503,962453,287598,149978,910532,932575,518335,244274,995674,55895,37778,560891,306136,757038,400810,87185,268645,101646,113576,690168,171747,264829,679542,94196,198872,374719,468867,197851,287985,490809,592802,465166,934369,916566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]