SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598198 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598198 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327552,1000641,431593,1000028,625483,349722,1041262,566296,348499,834403,995723,955992,760460,756709,510572,722695,4147,160996,260066,205846,473284,260598,705078,1001161,185397,594234,816940,859138,427619,1015036,48096,683491,853169,905589,247441,863176,107467,783001,450165,137557,409567,514818,882397,727464,121322,989320,741794,635532,556560,932469,181397,381589,336012,542326,876608,903416,934463,726578,631640,1047192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]