SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107982 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107982 [ RunTime:0.002053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489377,1013427,736277,467297,151029,489653,312853,448669,1035928,616246,785529,790797,649336,621659,846319,272524,385314,226062,56669,237030,112771,18403,551398,676165,238096,472871,102763,291431,514643,822491,384808,168227,66796,347416,313163,597556,713489,735139,564086,650710,325714,722854,233300,788259,689602,809922,902640,276661,835645,365291,714476,631475,1011853,528026,362971,172955,466221,531453,963734,857861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]