SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509920 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509920 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401216,836469,37816,537942,902781,48713,439010,467989,888643,912947,1000459,289161,546718,802022,170245,626820,920040,22188,826157,1014517,320639,243550,350957,915941,779648,1007881,1014885,527721,315054,819154,244349,198222,2325,951029,552059,721641,250158,148728,239501,787927,197387,98505,725968,715563,954805,504160,227515,734670,34715,381604,378743,953744,382151,749110,374419,568298,87575,20654,146,970205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001046s ]