SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283098 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283098 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39441,425005,492270,511938,276239,307580,194699,131375,530286,265203,1043870,1041077,750277,85015,570227,78540,1029644,300120,83209,523996,43723,361805,596700,442720,912118,829188,129964,857124,217698,225263,606738,346744,686088,969082,939679,887612,438690,80542,704246,321204,89055,844359,990019,223039,850463,572107,665856,215660,405855,937154,872797,838014,132291,857681,488628,472742,504273,236765,822342,893475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002299s ]