SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522159 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522159 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534741,204313,724827,650105,493696,831213,806490,544752,623940,620419,645383,881464,706405,172689,533089,802526,178832,722455,830264,314510,335263,237199,611108,472634,379567,394959,493138,452215,518690,128523,214376,598454,274078,490890,966441,784580,605246,96227,1988,461007,304981,715560,906912,355208,243077,193557,629502,923797,753844,19064,613348,963317,181893,952905,936534,1024609,629878,596043,649656,691233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]