SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861980 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861980 [ RunTime:0.002477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105411,427556,561474,612203,977513,130490,1026626,245973,691751,991089,529633,602517,563508,199752,525462,28115,497082,117241,917324,954828,271896,264989,171901,614681,864083,124154,372365,495994,833789,442063,302593,773697,715101,269307,873228,23397,755584,807804,877032,505481,419713,935998,13590,582736,643687,236131,476945,1007428,508541,707876,554362,384735,230327,569355,1008983,809982,838071,654072,542023,524902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]