SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914513 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914513 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689061,948329,864237,816184,961816,110627,1001339,390621,1031683,148052,359112,765696,654522,199896,98656,340329,52054,1040894,498949,233117,434780,347810,538147,1040362,617397,323507,148862,748037,352451,514342,252196,150228,793548,665317,26167,802410,418009,737212,734274,145187,463329,513231,328027,559837,11324,475209,296312,162605,285071,747922,1003638,964001,576490,1030577,364896,78824,915044,908248,306440,587513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]