SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584581 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584581 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983297,840855,682889,241316,617628,560140,881326,906471,611724,379642,201080,656298,43843,310302,405289,988834,30679,739934,837963,472505,603915,615476,331053,694470,440970,915875,42320,500924,219452,906783,527934,92504,463633,707322,1031992,800366,47490,289272,346422,538105,345371,436385,427077,523468,780504,497872,372025,687710,599594,88823,702022,377583,275882,132870,580889,23420,495060,602238,112431,177067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]