SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198080 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198080 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47800,545480,370957,56844,117778,706347,545784,60574,961254,468742,523016,328268,556229,439378,540424,149096,823799,907249,112359,553174,202119,817155,352072,95433,724838,466766,530982,6764,505877,153079,429617,778531,553061,438991,428752,468052,547754,504638,350862,241995,20580,882204,477493,658736,260899,524682,668975,591732,459058,385995,938225,414718,89224,330346,500694,72200,502940,764017,477334,845364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002285s ]