SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596630 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596630 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340689,97214,21095,48161,203320,893977,133380,537436,585075,916449,681357,484885,849381,822617,654700,2163,131892,445895,1014298,453138,801951,26201,302008,657428,92379,431093,751944,952743,534999,377058,766831,349761,542084,538216,413980,338086,102398,454376,768049,198317,284191,865126,619839,374670,964057,841946,823551,474570,330866,101543,828630,153899,657745,757278,247575,542416,194138,991906,930581,89867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]