SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416421 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416421 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535914,507581,457162,887399,499283,903998,582902,57633,597654,842022,156012,457021,731378,320529,797210,504591,1029984,426774,224498,858185,694417,901314,575096,446236,548410,736448,426813,39504,893659,561216,756435,194522,903938,1009082,27989,426673,16932,501314,470194,501050,272939,528487,115659,330877,165796,264218,101408,888771,832236,996757,822660,946278,719139,796858,693647,1017142,304267,635652,821358,502743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]