SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022676 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022676 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549065,106558,855909,241056,273539,348216,559131,841988,553790,285804,546981,271959,538096,60067,735228,705795,687240,615622,239691,923295,381001,679001,636045,811503,375093,1002376,32326,820284,294392,744561,480884,6926,352592,226231,462161,693209,743548,200096,271547,676412,412932,421457,1027852,404919,887514,661,841826,544647,570294,233911,521778,240108,940548,106618,712111,278671,464850,178967,590142,268068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]