SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681201 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681201 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348866,802202,693355,662793,42284,982942,573954,801739,646354,682299,910135,163304,241826,672294,290392,812455,459470,100288,849981,941995,818448,974411,409005,883636,648031,638206,144646,195587,437993,391439,789212,735170,265353,733311,960144,285214,242090,215775,109959,568385,1000500,1040051,703632,786401,660588,357965,796795,534700,700221,770342,394719,479172,263063,734090,414307,44823,8085,393005,466680,64693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001408s ]