SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 713294 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 713294 [ RunTime:0.004059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901267,835041,587017,236618,470642,92063,336003,815503,934065,840288,286567,614462,287891,601323,845048,698055,821995,1046049,133080,106540,782939,668378,795801,13408,946033,192710,378605,343287,561817,71340,271476,321505,425726,903124,6399,358560,308898,147229,139848,657191,493667,221880,1001910,883916,717254,678260,944046,616127,888908,1010178,31553,504629,321419,34396,140515,445687,966013,812114,754647,919761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 713294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 713294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001585s ]