SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319810 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319810 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210579,897278,337405,89275,541776,42700,418718,1032510,654295,184347,974883,950440,365815,518629,333625,393539,351864,527778,572997,1034752,242048,501744,636587,810011,160199,640327,156789,328859,786304,751211,474776,40172,752688,10093,733960,500331,317304,554484,438218,334375,831804,115469,382751,162100,130302,199224,873924,838177,841414,559875,915240,473966,590725,939889,525758,514374,108926,740920,841735,563874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]