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` = 310186 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310186 [ RunTime:0.006512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91726,256096,170235,214067,480311,833502,78934,391925,907713,715686,681938,17179,280008,1038193,466686,758050,936778,983617,909684,465261,136719,906190,629514,864635,672705,1008561,959071,1048340,77286,701443,210914,66042,999112,922766,688153,768022,992419,721641,928951,567740,233474,364975,619990,857460,336767,613221,902917,920703,513751,425144,313659,745286,71196,320773,492960,304130,913744,740487,552648,933274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002145s ]