SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479238 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479238 [ RunTime:0.002763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818151,290896,315862,900870,371551,398366,280245,660804,405983,351991,306568,959479,902752,1005299,603435,383166,451689,67891,732828,897717,981977,973360,850735,643274,802209,964441,21239,852304,165535,753563,970620,821002,924740,447848,198705,927313,984478,1022533,126300,679706,60994,111120,102588,144229,954256,428975,907257,514151,33508,801827,722973,299086,405535,376550,116303,504237,975604,393118,676864,768065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]