SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512811 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512811 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649903,745374,1000616,789896,428741,211162,541761,742106,520680,107908,597817,223896,928594,259463,599592,380196,822107,218390,174472,493126,1028276,819621,135831,863960,672279,650016,32690,566542,582728,668960,402686,275319,127098,722711,61523,836866,622737,311631,953664,514835,163072,26594,982399,861772,504452,793123,515552,438070,691402,10227,320370,909709,265631,622882,945101,35890,283141,746590,537460,311970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]