SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498263 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498263 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018731,396823,998224,630051,873489,936588,618443,37263,491960,885577,49755,209883,357066,753814,1047741,721159,1047750,478133,242847,767839,464099,182939,246239,188884,443946,505476,52677,943102,914768,827091,365518,180510,859549,844496,273842,911194,17896,509499,846382,335834,848656,655959,775300,191087,992993,242007,23619,251680,951453,686973,841202,1017083,791673,577160,1004523,589144,184000,988486,982291,925059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]