SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281940 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281940 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032385,559161,1028865,687426,191125,859836,427115,81809,396752,124165,490680,566126,1028730,529500,671163,136613,458574,668148,31247,1037860,248159,1044904,302694,218710,770759,629471,285432,950257,516282,434523,852363,285300,78798,469576,694772,983581,144890,100939,255327,414401,760271,764746,635022,588589,712147,770798,104182,612883,308593,251243,148615,407781,835488,779506,933261,230621,760004,975936,582843,335007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]