SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422617 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422617 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75636,938405,883971,414763,324066,536312,116163,950458,693553,596707,511263,889082,750762,162513,116401,490386,22486,45608,161728,553742,776405,831572,576651,838841,908387,28592,781353,560428,988234,41431,130328,430390,721084,677866,221797,510193,102119,268467,823101,1029124,1002092,988654,773361,468230,103711,458140,310499,422923,365043,576489,993239,277973,26563,122439,194556,778228,502686,199159,937935,405670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]